Datedif formula
 

I am trying to figure out the number of months between a start date and the
current month. I am using the formula =DATEDIF(MONTH(TODAY()),G4,"m") but it
is giving me the wrong answer. Ex. the start date is Sep-07 and it is
returning 1291 as an answer and the column is formatted as number. Can you
please help me. Thanks

Datedif formula
 

Marci --

I think you have the arguments backwards. Using A1 as my start date, I typed

=DATEDIF(A1,TODAY(),"M")

and got a result of 7, which I think is right.

HTH

"Marci" wrote:

I am trying to figure out the number of months between a start date and the
current month. I am using the formula =DATEDIF(MONTH(TODAY()),G4,"m") but it
is giving me the wrong answer. Ex. the start date is Sep-07 and it is
returning 1291 as an answer and the column is formatted as number. Can you
please help me. Thanks

Datedif formula
 

Assuming that the start date is in G4, try:

=DATEDIF(G4,TODAY(),"m")

However, as you say the Start date is Sep-07, if you mean 1st September 2007
then use:

=DATEDIF(DATE(YEAR(G4),MONTH(G4),1),TODAY(),"m")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Marci" <u43020@uwe wrote in message news:82e04247ddd20@uwe...
I am trying to figure out the number of months between a start date and the
current month. I am using the formula =DATEDIF(MONTH(TODAY()),G4,"m") but
it
is giving me the wrong answer. Ex. the start date is Sep-07 and it is
returning 1291 as an answer and the column is formatted as number. Can you
please help me. Thanks

Datedif formula
 

That worked...Thanks!

pdberger wrote:
Marci --

I think you have the arguments backwards. Using A1 as my start date, I typed

=DATEDIF(A1,TODAY(),"M")

and got a result of 7, which I think is right.

HTH

I am trying to figure out the number of months between a start date and the
current month. I am using the formula =DATEDIF(MONTH(TODAY()),G4,"m") but it
is giving me the wrong answer. Ex. the start date is Sep-07 and it is
returning 1291 as an answer and the column is formatted as number. Can you
please help me. Thanks