Date Range & Difference
 

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...

--
Thanks & have a great time always
pm_arrow

Date Range & Difference
 

Check out the DATEDIF function - examples he

http://www.cpearson.com/excel/datedif.aspx

Hope this helps.

Pete

On Oct 29, 2:39 pm, pm_arrow
wrote:
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...

--
Thanks & have a great time always
pm_arrow

Date Range & Difference
 

=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)

"pm_arrow" wrote in message
...
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...

--
Thanks & have a great time always
pm_arrow