To add a date in Excel, the most common methods are:
- Insert the current date as a static value by pressing the keyboard shortcut Ctrl + ; (semi-colon). This date will not change when the sheet is refreshed.
- Use the formula =TODAY() to insert the current date dynamically, which updates each time the workbook is opened.
- Enter a specific date manually in a cell, such as "22/03/2021" or "March 22, 2021".
- Use the DATE function to insert a date from year, month, and day components, e.g., =DATE(2021,3,22).
Additional tips:
- To insert the current time, press Ctrl + Shift + ;.
- To insert the current date and time together, press Ctrl + ; then Space then Ctrl + Shift + ;.
- For adding or subtracting days, months, or years to a date, you can use arithmetic operations or functions such as DATE and EDATE.
This provides flexible ways to add and manage dates in Excel according to your needs.
