View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default How to calculate number of month from 2008 in Excel?


It depends how you define the difference between months, A simple answer
which is close to what you want is
=(DATE(2008,12,31)-TODAY())/365.25*12

How bothered are you about the 31 and this will give a different
reading as all months are not the same length than the literal number
of months, but it is very close

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509270