Solve 1st of month after specified number of days elapsed

  • Thread starter Thread starter Guest
  • Start date Start date
Or, for the 1st of the month for the *next* month:

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

Biff
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for elapsed time 3
Excel Message box with days of month & date. 1
1st Wed, 1st Sat, 1st Sun 5
Excel 2003: Count total days elapsed 12
day of Month 8
Please Help With Days Elapsed And Days Remaining Calculation 2
formula for tracking number of elapsed days from a stard date 1
Calculate Elapsed Date and Time 3

Back
Top