Thread
:
Counting Months
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
Counting Months
=DATEDIF(a2,a1,"m")
--
Don Guillett
SalesAid Software
"jermsalerms"
wrote in message
...
Cell A1 is a date and cell A2 is a date.
what formula can I use to make A3 return the correct amount of months
between these two dates.
Example:
A1 = 6/1/2006
A2 = 9/01/2007
A3 = 15
PS - A1 and A2 are formatted as DATES
--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread:
http://www.excelforum.com/showthread...hreadid=548738
Reply With Quote