Thread
:
Computing full Months
View Single Post
#
4
Don Guillett
Posts: n/a
One way
=DATE(YEAR(H3),MONTH(H3)+4,1)
--
Don Guillett
SalesAid Software
"Mike M." wrote in message
...
Having trouble writing a formula that will add 3 full months to a hire
date
and the result starts with day 1 in the month.
Example:
Hire Date 1/10/2005
The 3 "full months after hire are Feb, Mar, Apr.
Want result to be May 1, 2005.
Can anyone help?
Reply With Quote