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.
Many thanks in advance.