counting number of days between anniversary day and payment due date

Re: counting number of days between anniversary day and payment due date

Quote from Wafoun;679179

hi
i am trying to get the number of days from last time ticket paid till todate, considering the day & month of the hiring date but the year of the last time paid.
say
AAA hired on 15-Nov-2001 receives a ticket every 24 months; received last ticket in Nov 2011.

i want to count
the number of days between 15-Nov 2011 until 31-Jul-2013 (dd & mm are from joining date yyyy from last time paid)
i have a list of 1200 names with different dates of joining and different dates of payments.
thank you

Display More

Could you upload your workbook?

Re: counting number of days between anniversary day and payment due date

=$G$4-DATE(YEAR(D5),MONTH(E5),DAY(E5))
G4 is 31/07/2013
The answer is 1583 for the first line.
Otherwise Could you state the disired result?

Re: counting number of days between anniversary day and payment due date

You are welcome.