
Create a list of sequential dates - Microsoft Support
You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
DATE function - Microsoft Support
You can use the DATE function to create a date that is based on another cell’s date. For example, you can use the YEAR, MONTH, and DAY functions to create an anniversary date that’s based on …
Add or subtract dates - Microsoft Support
You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel.
Calculate the difference between two dates - Microsoft Support
How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
Display or change dates on a category axis - Microsoft Support
When you create a chart from worksheet data that uses dates, and the dates are plotted along the horizontal (category) axis in the chart, Excel automatically changes the category axis to a date (time …
Format a date the way you want in Excel - Microsoft Support
Feb 2, 2012 · If you don’t like the default date format, you can pick a different one in Excel, like February 2, 2012 or 2/2/12. You can also create your own custom format in Excel.
Present your data in a Gantt chart in Excel - Microsoft Support
Learn how to create a Gantt chart in Excel. Create a Gantt chart to present your data, schedule your project tasks, or track your progress in Excel.
Insert the current date and time in a cell - Microsoft Support
To insert the date, type the date, for example 2/2, and then select Home > Number Format dropdown > Short Date or Long Date. To insert the time, type the time, and then select Home > Number Format …
Create a timeline - Microsoft Support
Learn how to create a timeline in Microsoft Office apps. Create a graphical representation of a sequence of events with the SmartArt graphic timeline.