To calculate a date that's a given number of months into the future or into the past, use the EDATE function. Returns the same day of the month used in the starting date, but adjusts for end of the month anomalies. Use EOMONTH to calculate the last day of the month a given number of months later or before
- [Voiceover] On this worksheet called EDATE-EOMONTH,…we need to calculate in column D…when this probationary period ends for…a person beginning in row two,…first of all, starting date April 26, three months.…The word month can mean different things.…I think you know at different times it means 28, 29, 30, 31.…We wanna move three months into the future here.…We can do this to come up with that exact day of the month.…Equals edate, left parenthesis.…Here's our starting date, it's in cell B2, comma,…and we wanna move forward three months.…
Now, you see, dates like this, that's the date value.…We can simply copy the format from over here in column B,…use the right mouse button,…drag this over into column D,…let go of the right mouse button,…Copy Here as Formats Only.…So, probably no surprises there.…April 26, July 26, we've got a few more here,…and we can move ahead this way.…Now look at some of these entries here…near the end of the month.…How about that entry in row five?…December 30, February 29, obviously there is no February 30,…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Calculate end-of-month with EOMONTH, future/past with EDATE