Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Spreadsheet Basics!
You have completed Spreadsheet Basics!
Preview
EDATE is a useful way to save yourself time from having to write out dates repeatedly. EDATE uses months, and calculates time differences based on a value in months that you enter into the formula.
Example Files
- you can continue to use the spreadsheet from the last video, or
- open a copy of this spreadsheet to catch up to this video
Reference
Related Functions
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
example, when calculating interest
payments based on days in a month or year.
0:00
EDATE is a useful way to save yourself time
from having to write out dates repeatedly.
0:04
This is useful if you are building
a spreadsheet that covers multiple
0:09
time periods, or
has to be consistently updated over time.
0:11
Let's take a look at an example of EDATE.
0:15
First, I'm just gonna enter a random date,
January 1st, 2017, completely arbitrary.
0:17
Then, let's look through
the syntax of EDATE.
0:25
EDATE uses months and
calculates time differences based on
0:28
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up