Excel Date Guides
When a date formula behaves unexpectedly, check what the cell stores before changing the formula. A displayed date may be text, while a timestamp may contain both a date and a time. Start with conversion or extraction for imported data, then use the calculation guide to understand how Excel works with the resulting values. The function references provide syntax you can use while adapting the examples to your own sheet.
Prepare dates for calculations
- Convert text into a date
Check imported values and turn date strings into Excel dates.
- Extract the date from a timestamp
Separate the date part before grouping or comparing records.
- Understand date and time calculations
Work through the values behind Excel's date and time display.
Check function syntax
- DATE function reference
Build a date from its year, month, and day.
- DATEVALUE function reference
Check the arguments and limitations when converting a date string.
All articles on this topic
5 articles
How to Make a Gantt Chart in Excel
Make a Gantt chart in Excel with start dates and durations. Follow a five-task example, fix date-axis settings, and download the sample workbook....
How to Add or Subtract Months from a Date in Excel
Use EDATE to add or subtract months from a date, handle January 31 and leap years, and keep renewal dates tied to the original start date....
How to Insert a Timestamp in Excel: Static, Dynamic, and Automatic Methods
Insert a fixed timestamp with Excel shortcuts, show the current time with NOW, or record data entry with an iterative formula or VBA....
How to Quickly Convert 1904 Dates to the 1900 Date System in Excel
Learn how to convert 1904 date system values to the 1900 date system in Excel. This guide covers methods for accurate date and date systems management in Excel....
Create a Date Schedule in Excel: Daily, Monthly, and Weekdays
Create daily, weekly, and weekday date lists with Fill Series, then build a monthly schedule that updates from one fixed starting date....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us