Dates and times
Date and time functions are one of the most frustrating but useful features of Excel. Check out these tutorials to learn the ropes.
- Date and time function overview. Excel uses a variety of special formatting types and functions to handle date and time inputs. Learn how and when to use them here!
- Parsing dates using Excel's DAY, MONTH, YEAR, and WEEKDAY functions. DAY, MONTH, YEAR, and WEEKDAY are used to extract more specific information from a date-formatted cell. Learn how to use them here!
- Excel's HOUR, MINUTE, and SECOND functions. HOUR, MINUTE, and SECOND help you extract hour (0-23), minute (0-59), and second (0-59) values from a time. Learn how to use them here!
- Finding the beginning and ending dates of months using the EOMONTH function. EOMONTH allows you to find both the beginning and ending dates of months easily in Excel. Learn how to use it here!