Join Dennis Taylor for an in-depth discussion in this video EOMONTH and EDATE: Calculating ends of months and future/past dates, part of Working with Dates and Times in Excel 2010.
When working with Date information, sometimes you need to calculate dates into…the future and from the past.…For example, in Column A here, we have some starting dates.…We want to calculate the 3rd anniversary.…Now 3rd anniversary might mean years, it might mean months, but either way, a…function called EDATE will allow us to handle this. =EDATE, left…parenthesis, our starting date in this case is cell A2, the three month…anniversary, we will simply put in 3, will be the 15th of October, and quick…double click here to copy these down the column, and we will see what's…happening in all cases.…
So you don't have to worry about the actual number of days, because that…varies, but this simply says three months out using the same day, and what…might happen here if, for example, one of these dates, and I will change one…of them on purpose here.…Let me pick a date here where it does cross into months that don't have 31 days.…We will use the one right here. Change this to be 31.…Of course, there is no 31st of April, so as you might expect here we do get 30th of April.…
- Understanding how Excel records and stores dates and times
- Looking at standard date/time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Exploring keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Rounding calculations
- Working with holidays
- Validating with dates
- Converting formatted dates to usable data
Skill Level Intermediate
Excel 2010: Advanced Formatting Techniqueswith Dennis Taylor3h 2m Intermediate
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Date/Time Functions
5. Calculating with Dates and Times
6. Using Dates and Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.