Days ago calculator

Days ago counts back a number of days from today, or from a date you pick, and shows the date it was and its weekday. Today counts as day zero, so 1 day ago is yesterday. You also see the weeks and business days in between and the matching spreadsheet formula.

30 days ago was

Friday, October 16, 2026

That was 4 weeks and 2 days ago.

See the full page for 30 days ago

Quick answers

Counted back from today, Sunday, November 15, 2026. Each one has its own page with conversions and a spreadsheet formula.

How it's calculated

Yesterday is 1 day ago, so N days ago is today's date minus N; today itself isn't counted. Everything follows your own time zone.

In Excel or Google Sheets

30 days ago: =TODAY()-30
From a date in cell A1: =A1-30

More date calculators

Frequently asked questions

Does "days ago" include today?

No. Yesterday was 1 day ago, so 30 days ago is today's date minus 30.

How do I count back from another date?

Change the start date in the calculator. The spreadsheet version is =A1-30 with your date in cell A1.

How far back can I go?

Up to 3,650 days, about ten years. For longer spans, the date duration calculator works with any two dates.