- Today Function Example 1
View an example using Excel’s Today Function along with other Date Type functions to answer various questions about someone’s age if given a birthdate.
- Year(), Month(), and Day() Function Examples
View an example using Year, Month, and Day functions to extract those separate values from a complete date value in a spreadsheet cell.
- Date() Function Examples
View examples of Excel’s DATE() function used to construct specific dates when given the correct year, month, and day to build with.
- Date Type Functions Challenge 1
Challenge yourself to use Excel’s Date type functions: Today, Day, Month, Year, and Date to find useful dates and ages related to a set of famous people, given their birthdates.
- Date Type Functions Challenge 2
Challenge yourself to calculate potential expiration dates of various foods by using several date type functions and logical functions appropriately.
- Introduction to Date Type Functions
An introduction to working with dates in Excel using the TODAY(), DATE(), YEAR(), MONTH,() and DAY() functions.
