Feb 2, 2009 · When you enter a date or time again, Excel displays the default date or time format. To enter a specific date or time format, such as January 2010, you can format it as text by …

You can insert the current date and time in an Excel cell as static values or as dynamic values. A static value is one that doesn’t change when the worksheet is recalculated or opened. A …

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.

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 …

You will need to change the number format (Format Cells) in order to display a proper date. For example: =DATE (C2,A2,B2) combines the year from cell C2, the month from cell A2, and the …

How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.

Formulas that return dates and times as negative values can also show as #####. There are multiple ways to troubleshoot this such as, double-clicking the right edge of the column …

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.

The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.

You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.