How to Enter a Date

By default, date is "MM/DD/YYYY" format in Excel. You can format a date to different styles, but the format in formula bar will not be changed.

– How to Enter a Number
– How to Enter a Fraction
– How to Enter a Time
– How to Enter Text Content

1. To Enter a Regular Date

Step 1. Select a cell and enter Month (e.g., 2);

Step 2. Enter slash;

Step 3. Enter Day (e.g., 12);

Step 4. Enter slash;

Step 5. Enter Year (e.g., 2011), you may need to format to a different style.

2. To Enter Today

When entering today's date, you can use either a shortcut or the TODAY function.

  • Today Function

= TODAY ()

  • Excel Shortcut

Ctrl+; (semicolon)

Leave a Reply