I want to type in a date in A1 and then A2 calcualtes the following month....and so on.
Example: A1 = 4/1/2012 and the A2 returns the value 5/1/2012....A3 would be 06/1/2012 and so on.
I want to type in a date in A1 and then A2 calcualtes the following month....and so on.
Example: A1 = 4/1/2012 and the A2 returns the value 5/1/2012....A3 would be 06/1/2012 and so on.
Last edited by johnsoncj2002; 11-23-2011 at 04:07 PM. Reason: Solved
In A2 enter =date(year(A1), month(A1)+1,day(A1)), etc...
Hi,
In Excel 2007-->
in 2003Please Login or Register to view this content.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Copy and paste this formula in A2 and drag it down
=DATE(2012,ROW()+3,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks