Solve 1st of month after specified number of days elapsed
 

Solve 1st of month after specified number of days elapsed
 

And the question is?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MH" wrote in message
...

Solve 1st of month after specified number of days elapsed
 

Date + n - DAY(Date + n) + 1

Biff

"MH" wrote in message
...

Solve 1st of month after specified number of days elapsed
 

Or, for the 1st of the month for the *next* month:

=DATE(YEAR(Date + n),MONTH(Date + n)+1,1)

Biff

"T. Valko" wrote in message
...
Date + n - DAY(Date + n) + 1

Biff

"MH" wrote in message
...

Solve 1st of month after specified number of days elapsed
 

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
...

Solve 1st of month after specified number of days elapsed
 

=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
...

Solve 1st of month after specified number of days elapsed
 

Thank you.

"T. Valko" wrote:

Or, for the 1st of the month for the *next* month:

=DATE(YEAR(Date + n),MONTH(Date + n)+1,1)

Biff

"T. Valko" wrote in message
...
Date + n - DAY(Date + n) + 1

Biff

"MH" wrote in message
...

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
...

Solve 1st of month after specified number of days elapsed
 

You're welcome!

Biff

"MH" wrote in message
...
Thank you.

"T. Valko" wrote:

Or, for the 1st of the month for the *next* month:

=DATE(YEAR(Date + n),MONTH(Date + n)+1,1)

Biff

"T. Valko" wrote in message
...
Date + n - DAY(Date + n) + 1

Biff

"MH" wrote in message
...