MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date formula help?

Posted by LoriD on October 12, 2001 7:39 AM

I have a date in A1. In A2 I want to enter a formula so that the same month, next year will appear. I tried entering A1+365, and formatting the cell mm-yy, but if the date in 1 happens to be a 31-day month, it gives me the next month next year. Is there a way to do this?

Posted by Aladin Akyurek on October 12, 2001 7:42 AM

=EDATE(A1,12). (NT)