Does anyone have suggestions on how to write a formula that automatically increases the month by 1 in the below cell. I don't wan't it be just rolling for just 12 months but rather continue down for as long as I drag the formula...
So in A1, when the use puts in eg May-12, A2 should automatically say Jun-12, A3 Jul-12 etc
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Many thanks!
Last edited by Ings; 06-20-2013 at 08:15 PM.
Try in A2 copied down...
=DATE(YEAR(A1),MONTH(A1)+1,1)
HTH
Regards, Jeff
A2: =EDATE(A1,1)
copy down as far as needed
=EOMONTH(A1,1) drag down.
:D
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks