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