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
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
=DATEDIF(a2,a1,"m")
--
Don Guillett
SalesAid Software
[email protected]
"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
one way
=(A2-A1)/30.42
format as number --no decimals.
--
Greetings from New Zealand
Bill K
"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
=(YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)
Format as standard
"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
=DATEDIF(A1,A2,"m")
http://www.cpearson.com/excel/datedif.htm
--
David Biddulph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks