Join Dennis Taylor for an in-depth discussion in this video Using date functions in data validation rules, part of Working with Dates and Times in Excel 2007.
If you are familiar with Excel Date functions, you can use them in a creative…way, along with Excel's Data Validation capability.…In this particular worksheet, there is a Data Validation rule in place in…column B, and that rule is that no entry in column B can be within two…days of the Order Date.…And the way that formula is stated here, =B1>A1+2…refers to all entries in column B. They must be more than two days later than…the Order Date in column A.…
It so happens that in setting this up maybe you weren't thinking about when…that shipping date is.…What day of the week is this? =weekday.…This function will tell us that, and if it's a 1, it means it's Sunday.…Well, you don't do shipping on Sunday.…So you want to make sure that this date is not a Sunday.…Now, its already been entered, so we'll either have to manually take it out or…correct it, but let's say that you want to change the rule to also include…this limitation here, that the weekday is not equal to 1, and furthermore,…maybe you're thinking about Saturdays as well. Maybe you don't do shipping on Saturdays.…
- 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
Creating Business Budgets in Excel 2007with Curt Frye1h 3m Intermediate
Excel 2007: Introduction to Formulas and Functionswith Curt Frye2h 26m Intermediate
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Excel's 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.