On Sun, 15 May 2005 08:15:01 -0700, "Mike M."
wrote:
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?
Assuming that if Hire Date is 1 Jan 2005, then the result would be 1 Apr 2005;
but if the Hire Date is after the first of Jan, then the result would be 1 May
2005:
=DATE(YEAR(A1-1),MONTH(A1-1)+4,1)
--ron
|