Profile image
By Stock Kevin (Reporter)
Contributor profile | More stories
Story Views

Last Hour:
Last 24 Hours:

Excel Tip #18 – Add One Year or Months to a Date

Tuesday, April 11, 2017 23:05
% of readers think this story is Fact. Add your two cents.

(Before It's News)

In finance and accounting we are constantly looking back or forward. Suppose you’ve been tasked to create a complex lease schedule or even a simple mortgage payment spreadsheet. While you can manually type in the dates for your 30 year mortgage schedule, that is most definitely time consuming. You don’t want to have to type everything in from 5/10/2017 all the way to 5/10/2047.

Suppose there was a formula that would be able to help you add one year to a date or even one month. What would that formula look like and how would it work?

Here is a two step process on how to quickly add one year to a date or even add one month. 

1) Use the EDATE() function and fill in the brackets () with the cell in which your start date resides

2) Follow your start date cell with a comma and then enter in the number of months you’d like to add


For more excel tips, be sure to visit the rest of our site.

Report abuse


Your Comments
Question   Razz  Sad   Evil  Exclaim  Smile  Redface  Biggrin  Surprised  Eek   Confused   Cool  LOL   Mad   Twisted  Rolleyes   Wink  Idea  Arrow  Neutral  Cry   Mr. Green

Top Stories
Recent Stories



Email this story
Email this story

If you really want to ban this commenter, please write down the reason:

If you really want to disable all recommended stories, click on OK button. After that, you will be redirect to your options page.