Date Range & Difference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey Gigs... Need your guidance...

I need to find the difference between list of dates and the result should be
in months - for eg. 01-01-06 minus 31-12-06 is equal to 12 months.

I am sure its an easy fix but i think i am not using the right date format.
Pl. help me...
 
=DATEDIF(A1,A2,"M")

gives 11 because it is whole months. You need to make a decision when a part
month is counted and when it is not, for intance does 12/12 count, or 8/1 to
20/12?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top