LinkBack URL
About LinkBacks
I enter 01/2011 and would like to add one month in the cell below. What would my formula on that below cell be?
I enter 01/2011 and would like to add one month in the cell below. What would my formula on that below cell be?
You can just pull down from the corner and select fill months
Hi,
would be:
=Date(year(above cell),month(above cell)+1,day(above cell))
assuming input in A1;
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)), and drag the function down...
Hope it helps,
-ben
Last edited by Sleever; 09-07-2014 at 01:46 PM. Reason: practical example added
Enter a valid date in A1 and =EDATE(A1,1) in A2
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try the following in A2 after entering the date in A1:
=EOMONTH(A1,1)
This will not add one month. It will show the last day of the month.Originally Posted by cbatrody
@ Alkey,
It will! Please check the attached file.
It will give you the last day of the next month. Just change the format on your spreadsheet from Custom to Date and you will see it.
If in A1 you have 1/1/2011 then in A2 with your formula you will see 2/29/2012
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks