Join Dennis Taylor for an in-depth discussion in this video WORKDAY: Calculating ending dates, part of Working with Dates and Times in Excel 2010.
If you need to tabulate the length of a project based on knowing the starting…date and project length and days, you can use the WORKDAY function to find the…End Date or the Target Date.…So on Cell D4 here, we want to figure out when this project ends, the one that…begins on May 27th and is 120 days in length.…Now if we're not thinking too clearly here, if we just want to do this kind…of fast, we might say, well, just simply add the two, in other words the…starting date plus this.…And of course, the answer does make sense in some context, because that's 120 days later.…
If this is 7 day a week operation, that makes perfect sense.…The project ends on September 24th.…But let's say it's a 5-day working project.…We do not want to count Saturdays and Sundays.…So we use the function WORKDAY. The starting date May 27th here, comma, the number of…days, that's 120 right here.…We'll ignore the holidays for the moment.…What's the real ending date of this project if we don't work Saturdays and…Sundays here, this environment.…
- 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.