# Date Calculation need for First of the month following 1 month

1. ## Date Calculation need for First of the month following 1 month

Hello Excel Forum. I'm looking for a formula that will return the correct date given a specified date in another cell. Specifically, the formula needs to return the date that is the First of the month following 1 month from the given date.

Example: If cell B2 contains the given date, then cell B4 needs a formula that will look at the given date in B2, add 1 month (not days, but literally 1 month, so if the given date is February 1st, the formula will add 1 month from Feb 1st which would be March 1st), and then return the correct date.

So any given date that has a 1st of the month date (e.g. 1/1, 2/1, 3/1, etc.), the formula should return a date that is exactly 1 month later (i.e. if given date is 2/1, the formula should return a result of 3/1).

If the given date is any day of the month other than the first day of the month (so days 2-31), then the formula should return a result that is the 1st of the month following (e.g. if given date is 1/2/14, the formula should return a result of 3/1/14).

Attached is a sample worksheet.

be well  Register To Reply

2. ## Re: Date Calculation need for First of the month following 1 month

This regular formula returns the 1st day of the month after the first full month of hire ``Please Login or Register  to view this content.``
Is that something you can work with?  Register To Reply

3. ## Re: Date Calculation need for First of the month following 1 month

Wonderful. Works perfectly. Thank you so much, Ron.

Be Well!  Register To Reply