counting number of days between anniversary day and payment due date

  • 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

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



    Could you upload your workbook?

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


    Appreciate your assistance. i have done my report so quick.
    Best wishes and loads of thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!