View Single Post
  #4   Report Post  
Don Guillett
 
Posts: n/a
Default

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?