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)
