How Many Days Has It Been Since January 28

You're staring at a calendar — maybe a paper one on the fridge, maybe your phone screen — and the question hits: how many days has it been since January 28?

It sounds simple. Plus, subtract, count, done. Does today count? But then you remember February. Plus, was it a leap year? Because of that, does January 28 count? And wait — are we talking calendar days or business days?

The answer changes depending on why you're asking. A landlord calculating a notice period needs something different than someone tracking a habit streak. A developer timestamping logs needs something different than a parent counting down to a half-birthday.

Let's walk through all of it. No fluff. Just the methods, the traps, and the tools that actually work.

What Is "Days Since January 28" Actually Asking?

At its core, this is a date difference calculation. You have a fixed start date — January 28 of some year — and you want the integer number of days between that date and today (or another end date).

But "days since" is ambiguous in ways that bite people constantly:

Inclusive vs. exclusive counting. If today is January 29, has it been 1 day or 2 days since January 28? Most people mean exclusive* — the number of midnights that have passed. But legal contracts, billing cycles, and some cultural traditions count inclusively.

Calendar days vs. business days. "Days since" usually means calendar days. But if you're calculating a payment deadline, a notice period, or an SLA, you likely need business days — and that means excluding weekends, maybe holidays, maybe half-days.

Time zones and cutoffs. January 28 at 11:59 PM in Tokyo is already January 29 in New York. If you're coordinating across regions, "since January 28" needs a timezone anchor.

Leap years. January 28, 2024 to January 28, 2025 is 366 days because February 29, 2024 exists. January 28, 2023 to January 28, 2024 is 365 days. The difference compounds over multi-year spans.

The Hidden Variable: Which Year?

"Since January 28" without a year is incomplete. Because of that, - January 28 of last* year? Are you measuring from:

January 28 of this* year?
A specific historical date — January 28, 1986 (Challenger disaster), January 28, 2003 (Columbia disaster), January 28, 2020 (first US COVID case confirmed)?

The year changes everything. Always specify it.

Why People Need This Calculation

You'd be surprised how often this exact question drives real decisions.

Legal and Contractual Deadlines

A lease says "30 days notice required." You gave notice January 28. When can you move out?

A statute of limitations runs "two years from the date of injury." The injury was January 28, 2022. When does it expire?

A credit card billing cycle closes "25 days after statement date." Statement date: January 28. Payment due when?

These aren't academic. Missing by one day costs money, rights, or housing.

Habit Tracking and Streaks

"I haven't had a drink since January 28.Even so, " "I've coded every day since January 28. " "I've run 5k daily since January 28.

People build identity around these streaks. Day 100 feels different than Day 99. Day 365 is a milestone. Because of that, the count matters psychologically. Getting the number wrong breaks the narrative.

Financial Calculations

Accrued interest. "Interest accrues daily from January 28." Days sales outstanding. "Invoice dated January 28, paid today — what's the DSO?But " Tax lot holding periods. "Bought January 28, sold today — short or long term?

One day flips a capital gains rate. One day changes qualified dividend status.

Project Management and SLA Tracking

"Ticket opened January 28. On top of that, sLA: 10 business days. And are we in breach? " "Sprint started January 28. Today is day X of 14. Which means on track? " "Warranty began January 28, 2022. Three-year coverage. Still valid?

Personal Milestones

Anniversaries. Even so, "Married January 28, 2018. How many days?" Sobriety dates. Practically speaking, "Clean since January 28, 2019. " Grief. "She died January 28. It's been X days.

These aren't calculations. They're rituals. The number carries weight.

How to Calculate It — Methods That Work

Method 1: The Spreadsheet Way (Most Reliable)

Open Excel, Google Sheets, or LibreOffice Calc.

Cell A1: =DATE(2024,1,28) — or whatever year you need Cell A2: =TODAY() — or a specific end date Cell A3: =A2-A1

Format A3 as Number. Done.

Sheets handles leap years, month boundaries, and Gregorian calendar quirks automatically. It's the gold standard for a reason.

Pro tip: For business days, use =NETWORKDAYS(A1, A2) — and optionally feed a holiday range as a third argument.

Method 2: Programming (For Automation)

Python:

from datetime import date
start = date(2024, 1, 28)
end = date.today()
delta = end - start
print(delta.days)

JavaScript:

const start = new Date('2024-01-28');
const end = new Date();
const diffMs = end - start;
const diffDays = Math.floor(diffMs / (1000 * 60 * 60 * 24));
console.log(diffDays);

SQL (PostgreSQL):

SELECT CURRENT_DATE - DATE '2024-01-28' AS days_since;

These give you the exclusive count — midnights passed. Add 1 if you need inclusive.

Method 3: Online Calculators (Quick One-Offs)

Timeanddate.com's date calculator. WolframAlpha. Calculator.net.

For more on this topic, read our article on how many days until july 24 or check out baby age calculator weeks to months.

Type "days since January 28 2024" into Google — it often answers directly in the search results.

Caution: Verify the calculator's counting convention. Some default to inclusive. Some assume UTC. Some don't handle pre-1900 dates well. Test with a known case first (e.g., Jan 28 to Jan 29 = 1 day exclusive).

Method 4: Mental Math (When You're Offline)

For same-year, same-month: trivial. January 28 to January 31 = 3 days.

Crossing months: memorize month lengths.

Jan 31, Feb 28/29, Mar 3
Apr 30, May 31, Jun 30, Jul 31, Aug 31, Sep 30, Oct 31, Nov 30, Dec 31.

Add remaining days in start month + full months between + days in end month.

Leap year rule: Divisible by 4, except centuries not divisible by 400.2024? Leap. 2100? Not leap. 2000? Leap.

Cross-year: Days left in start year + full years × 365 + leap days in between + days into end year.

Example: Jan 28, 2022 → Jan 28, 2024.2022: 365 - 28 = 337 (non-leap, Jan 28 is day 28)
2023: 365
2024: 28 (Jan 28 is day 28, 2024 is leap but Feb 29 hasn't happened)
Total: 337 + 365 + 28 = 730 days. Exactly two years. Checks out.

Edge Cases That Break Things

Time Zones and Midnight

TODAY() in Sheets uses the spreadsheet's timezone. date.today() in Python uses the system's local date. new Date() in JavaScript uses the browser's timezone.

If it's 11 PM January 27 in Los Angeles but 2 AM January 28 in London, "today" differs. For legal or financial deadlines, specify the timezone explicitly.

# Python: force UTC
from datetime import datetime, timezone
start = datetime(2024, 1, 28, tzinfo=timezone.utc)
end = datetime.now(timezone.utc)
print((end - start).days)

Daylight Saving Transitions

March and November transitions create 23-hour and 25-hour days. If you're counting hours* and dividing by 24, you'll drift. Count midnights passed, not hours elapsed. The date type (not datetime) avoids this entirely.

Leap Seconds

Irrelevant for day counts. They adjust UTC, not the calendar date.

Inclusive vs. Exclusive — The Eternal Ambiguity

Exclusive (midnights passed): Jan 28 → Jan 29 = 1 day. Standard for interest, DSO, holding periods.
Inclusive (both endpoints counted): Jan 28 → Jan 29 = 2 days. Common in "days on market," hospital length-of-stay, some regulatory reporting.

Always state your convention. =A2-A1 is exclusive. =A2-A1+1 is inclusive. Document it in the cell comment.

Business Days ≠ Calendar Days

NETWORKDAYS excludes weekends. But holidays vary by country, state, exchange, and company. The NYSE observes Good Friday; the Fed does not. Your company observes the Friday after Thanksgiving; your vendor may not. Pass a holiday list. Never assume.

Pre-1900 Dates

Excel's date system starts January 1, 1900 (and incorrectly treats 1900 as a leap year — a Lotus 1-2-3 compatibility bug preserved forever). Google Sheets matches this behavior for compatibility.

For historical work (genealogy, archival research), use Python's datetime (year 1–9999), R's lubridate, or specialized libraries like astral or skyfield for astronomical dating.

Why January 28?

No reason. And every reason.

It's the day the Space Shuttle Challenger* broke apart (1986).
The day the first Lego brick was patented (1958).
Plus, the day We Are the World* was recorded (1985). Practically speaking, data Privacy Day. Kazakhstan's Army Day.
On top of that, your mother's birthday. Worth adding: the day you quit. The day they left.

The date is arbitrary. The interval is not.

Summary: Choose Your Tool, Define Your Terms

Need	Tool	Watch For
One-off, auditable	Spreadsheet (`=A2-A1`)	Time

Need	Tool	Watch For
One-off, auditable	Spreadsheet (`=A2-A1`)	Timezone ambiguity
Time zone-sensitive calculations	Python/JS with explicit TZ	Use `datetime` with `tzinfo` or `moment.js`
Historical dates <1900	Python (`datetime`), R (`lubridate`)	Excel/Sheets break pre-1900
Business days with holidays	Spreadsheets (`NETWORKDAYS`)	Curate holiday lists per jurisdiction
DST-aware intervals	Date types (not datetime)	Count midnights, not hours

Final Thoughts: Context Is King

Date math isn’t just arithmetic—it’s a negotiation between human conventions and technical systems. On top of that, the "right" answer depends on why you’re counting. On top of that, for a mortgage, it’s business days and time zones. In real terms, for genealogy, it’s historical calendars and pre-1900 quirks. For a rocket launch, it’s leap seconds and GPS time.

The tools are flexible, but only if you define your terms. Practically speaking, write down your assumptions. But share your conventions. And when in doubt, ask: What does "day" mean here?

Because in the end, it’s not the date that matters—it’s the story you’re trying to tell.