How to Add Dates in Excel Automatically

What this does

"Add dates automatically" actually covers three different needs. A one-time timestamp — when an order was placed, when a form was submitted — wants Ctrl+; or Ctrl+Shift+;, which write a plain, unchanging value exactly like typing the date by hand. A value that should always reflect the current date or time — a dashboard header, an "as of" label, an age calculation — wants =TODAY() or =NOW(), volatile formulas that recompute on every open and every recalculation, meaning today's answer is gone the next time the file is opened. A SERIES of dates — a weekly schedule, a monthly report calendar — wants the fill handle or Fill ▸ Series, which is neither of the above: a static run of related dates generated once, not a formula and not a single repeated value. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “add dates in excel automatically”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. The point is a workflow that saves repeating the same clicks every week, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

A2 needs the exact date an invoice was created, fixed forever: Ctrl+; while A2 is selected writes 8/12/2026 as a plain value that stays 8/12/2026 no matter when the file is reopened. B1 instead needs to always show "as of" today's date on a dashboard: =TODAY() in B1 shows 8/12/2026 today and will automatically show 8/13/2026 tomorrow with no further action — correct for B1, but would have been wrong for A2's invoice date. For a column listing every Friday in Q3, type the first Friday in C2, right-click-drag the fill handle down, and choose "Fill Weekdays" from the menu that appears on release (or use Home ▸ Fill ▸ Series ▸ Date unit ▸ Day with a step of 7 to land on the same day each week — Date unit ▸ Weekday instead skips weekends and would NOT stay on Friday). A date that changes when it should not (or stays frozen when it should not) is one of the most common silent-error sources in a shared workbook, and the fix is simply matching the right one of these three tools — static shortcut, live formula, or a filled series — to what the cell is actually supposed to do. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.

In Google Sheets

Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “add dates in excel automatically” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.

Common mistakes

• Using =TODAY() for a date that should stay fixed (an invoice date, a submission timestamp) — it silently updates to a new date every time the file is reopened, so a record meant to be permanent quietly changes.
• Using Ctrl+; for a value that needs to stay current — it is a one-time snapshot, not a live formula, so it will NOT update tomorrow the way the task actually needed.
• Dragging the fill handle for a daily series and getting weekends included when only workdays were wanted — right-click-drag (or Fill ▸ Series ▸ Weekday) fills business days only; a plain left-drag fills every calendar day.
• =TODAY() and =NOW() are volatile — they recalculate on every sheet change, not just once a day, which can measurably slow a very large workbook that uses them across thousands of cells.

Frequently asked questions