Hi All
How do I add months to dates without working out the number of days in each month?
I know for example =A1+7 would add a week, =A1+28 would add 4 weeks. But I want to add months, regardless of how long each is.
Any Ideas?
Thanks for any help.
Roy
To add 3 months to the date in A1 you could use this.
Formula:
Please Login or Register to view this content.
If posting code please use code tags, see here.
=CHOOSE((MONTH(A1)=12)*1+1,DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),DATE(YEAR(A1)+1,1,DAY(A1)))
Edit - i thought you just wanted to add one month sorryI didn't realize excel could handle months greater than 12 either
Last edited by GeneralDisarray; 07-09-2014 at 10:34 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Try this......
The above formula will add 1 month to the date in A1. So if you want to add 6 months to the date in A1, it would be like this.....
Please Login or Register to view this content.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi All
Thanks for all your help.
The =EDATE worked perfectly
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks