Thread: Datedif formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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