US Trends

how to add date in excel

Here’s a clear, beginner-friendly guide on how to add date in Excel plus some handy extras you’ll actually use.

The absolute fastest way (static date)

Use this when you just want to stamp today’s date once and it should NOT change later.

  • Click the cell where you want the date.
  • On Windows: press Ctrl + ; (semicolon).
  • On Mac: press Cmd + ; (semicolon).

This inserts today’s date in your system’s default date format and it will stay fixed, even when you reopen the file tomorrow.

Add a date that updates automatically

Use this when you always want “today” whenever the file is opened (dynamic date).

1. Use the TODAY function (date only)

  • Click a cell.
  • Type: =TODAY()
  • Press Enter.

Excel will show today’s date and automatically update it each day when the workbook recalculates.

You can also do simple math with it, for example:

  • Date 5 days from today:
    =TODAY() + 5

2. Use the NOW function (date + time)

If you want date and time together:

  • Type: =NOW() and press Enter.

This shows current date and time and also updates.

Manually typing a date (and making sure Excel recognizes it)

You can just type the date, for example:

  • 1/31/2026
  • 31-01-2026 (depends on your regional settings)

Tips:

  • Make sure your format matches your system date settings, or Excel may treat it as text instead of a real date.
  • After typing, you can change the format (e.g., 31-Jan-2026, Jan-31-26) using:
    • Home → Number group → Date formats.

Keyboard shortcuts you should know

These are classics that save tons of time when entering many dates.

  • Insert current date (static):
    Ctrl + ; (Windows) or Cmd + ; (Mac).
  • Insert current time (static):
    Ctrl + Shift + ; (Windows).
  • Insert current date and time in one cell (static):
    1. Press Ctrl + ;
    2. Press Space
    3. Press Ctrl + Shift + ;

Auto-fill a list of dates (sequential days)

Use this for schedules, logs, or daily data.

  1. Type the first date in a cell (e.g., 01/02/2026).
  2. Click that cell once.
  3. Grab the small square in the bottom-right corner of the cell (the fill handle).
  4. Drag it down (or right) over the cells you want to fill.

Excel will automatically continue the dates day by day.

You can also right-click and drag the fill handle, release, then choose Series… to set step (e.g., every 7 days).

Adding or subtracting days from a date

Because Excel stores dates as serial numbers, you can add or subtract plain numbers.

  • If A1 contains a date, then:
    • 30 days after that date: =A1 + 30
    • 7 days before that date: =A1 - 7

Example:
If A1 is 01/02/2026, =A1+30 will show 31/03/2026 (depending on format).

More advanced: building dates with DATE + TODAY

Use this when you need precise control over year, month, and day.

1. DATE with fixed parts

To create a specific date:

  • =DATE(2026, 2, 15) → 15-Feb-2026.

2. Deadline a few months from today

Example: project due 3 months from now on the 15th:

  • =DATE(YEAR(TODAY()), MONTH(TODAY()) + 3, 15)

This takes the current year and month from TODAY(), adds 3 months, and sets the day to 15.

Quick HTML table of common methods

html

<table>
  <thead>
    <tr>
      <th>Goal</th>
      <th>What to do</th>
      <th>Example / Shortcut</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>Insert today’s date once (fixed)</td>
      <td>Select cell, use keyboard shortcut</td>
      <td>Windows: Ctrl+; &nbsp; Mac: Cmd+;</td>
    </tr>
    <tr>
      <td>Have date auto-update to “today”</td>
      <td>Use TODAY function</td>
      <td>=TODAY()</td>
    </tr>
    <tr>
      <td>Show date and time, auto-updating</td>
      <td>Use NOW function</td>
      <td>=NOW()</td>
    </tr>
    <tr>
      <td>Make a future date from today</td>
      <td>Add days to TODAY</td>
      <td>=TODAY()+5</td>
    </tr>
    <tr>
      <td>Create a specific date</td>
      <td>Use DATE(year, month, day)</td>
      <td>=DATE(2026,2,15)</td>
    </tr>
    <tr>
      <td>Fill consecutive dates down a column</td>
      <td>Type first date, drag fill handle</td>
      <td>Drag down to auto-fill days</td>
    </tr>
    <tr>
      <td>Add days to a date in a cell</td>
      <td>Use simple arithmetic</td>
      <td>=A1+30 (30 days after date in A1)</td>
    </tr>
  </tbody>
</table>

Mini “story” example

Imagine you’re tracking daily sales for February in Excel. On 1-Feb-2026, you type 01/02/2026 in A2, then drag the fill handle down to A29. Instantly, you get every date for the month filled in order, and you can type sales beside each one. If you also want a “Report last updated” cell that always shows today, you just put =TODAY() at the top, and it updates itself every time you open the file.

Information gathered from public forums or data available on the internet and portrayed here.