B
Bernard Liengme
And the question is?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
Date + n - DAY(Date + n) + 1
Biff
Biff
T
T. Valko
Or, for the 1st of the month for the *next* month:
=DATE(YEAR(Date + n),MONTH(Date + n)+1,1)
Biff
=DATE(YEAR(Date + n),MONTH(Date + n)+1,1)
Biff
M
MH
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.
a full 180 days of employment. I wanted to be able to enter the hire date
and have a cell compute the eligible date.
D
David Biddulph
=DATE(YEAR(A1+180),MONTH(A1+180)+1,1)
M
MH
Thank you.
T. Valko said:Or, for the 1st of the month for the *next* month:
=DATE(YEAR(Date + n),MONTH(Date + n)+1,1)
Biff
M
MH
T