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
|