Posted to microsoft.public.excel.worksheet.functions
|
|
Solve 1st of month after specified number of days elapsed
Thank you.
"David Biddulph" wrote:
=DATE(YEAR(A1+180),MONTH(A1+180)+1,1)
--
David Biddulph
"MH" wrote in message
...
An employee becomes eligible for benefits on the first of the month
following
a full 180 days of employment. I wanted to be able to enter the hire date
and have a cell compute the eligible date.
"Bernard Liengme" wrote:
And the question is?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"MH" wrote in message
...
|