Calculating the exact number of days between a past date and today is a common need, whether you are tracking a project milestone, calculating interest accrual, or simply satisfying curiosity about how much time has passed since a specific event. If you are wondering how many days since June 15, 2023, the answer depends entirely on the current date you are reading this.
As of May 22, 2025, there have been 707 days since June 15, 2023.
Because this number changes every single day, the most valuable approach is not just giving you a static number, but teaching you the methods to calculate it accurately for whatever date you are currently on. This guide covers manual calculation techniques, spreadsheet formulas, programming snippets, and the nuances of leap years that often trip people up That's the part that actually makes a difference. Simple as that..
Understanding the Baseline: June 15, 2023
Before diving into the math, let’s establish the context of the starting date. June 15, 2023, fell on a Thursday. It was the 166th day of the year (167th in leap years) with 199 days remaining until the end of the year.
Knowing the day of the week helps if you are calculating business days or weekdays specifically, but for a total "days elapsed" count, we focus purely on the calendar difference Small thing, real impact..
Method 1: Manual Calculation (The "Long Hand" Way)
Calculating manually is excellent for understanding the mechanics of the calendar. You essentially break the timeline into three chunks: the remaining days in the start year (2023), the full years in between (2024), and the days elapsed in the current year (2025) Most people skip this — try not to..
Step 1: Days Remaining in 2023 (After June 15)
Since June 15 is the start date, we typically exclude the start date in "days since" calculations (Day 0) Small thing, real impact..
- June: 30 total days - 15 days passed = 15 days remaining (June 16–30).
- July: 31 days
- August: 31 days
- September: 30 days
- October: 31 days
- November: 30 days
- December: 31 days
Total for 2023: 15 + 31 + 31 + 30 + 31 + 30 + 31 = 199 days Most people skip this — try not to..
Step 2: Full Years In Between (2024)
The year 2024 is a leap year (divisible by 4, not a century year exception). That's why, it has 366 days That's the part that actually makes a difference..
Step 3: Days Elapsed in Current Year (2025 up to May 22)
2025 is a standard year (365 days). We count days from Jan 1 up to the current date.
- January: 31 days
- February: 28 days (2025 is not a leap year)
- March: 31 days
- April: 30 days
- May: 22 days (up to May 22)
Total for 2025 (Jan 1 – May 22): 31 + 28 + 31 + 30 + 22 = 142 days.
The Grand Total (As of May 22, 2025)
199 (2023 remainder) + 366 (2024 full) + 142 (2025 elapsed) = 707 Days.
Important Note: If you want to include June 15, 2023, as "Day 1," you would add 1, making it 708 days. Standard "days since" calculators usually exclude the start date No workaround needed..
Method 2: Using Spreadsheet Software (Excel / Google Sheets)
At its core, the most reliable method for dynamic tracking. Spreadsheets store dates as serial numbers (integers), making subtraction instant.
The Simple Formula
Assume cell A1 contains the start date: 6/15/2023 (or 15-Jun-2023).
In cell B1, enter the current date. You can hardcode it or use the volatile function =TODAY().
Formula:
=B1 - A1
Format the result cell as Number (not Date) to see the integer count.
The DAYS Function (Modern Excel / Sheets)
This function is explicit and handles the order of arguments clearly (End Date, Start Date).
=DAYS(TODAY(), DATE(2023,6,15))
TODAY()updates automatically every time the sheet opens.DATE(2023,6,15)constructs the date safely regardless of your regional settings (US vs UK date formats).
Calculating Business Days Only (NETWORKDAYS)
If "days since" implies working days (excluding weekends and holidays), use NETWORKDAYS.
=NETWORKDAYS(DATE(2023,6,15), TODAY(), [holidays_range])
- The optional
[holidays_range]allows you to reference a list of specific public holiday dates to exclude them as well.
Method 3: Programming Approaches (Python, JavaScript, SQL)
For developers building apps, dashboards, or automated reports, hardcoding the calculation logic is standard practice The details matter here..
Python (datetime module)
Python’s standard library makes this trivial and timezone-aware if needed.
from datetime import date, datetime
start_date = date(2023, 6, 15)
# Use date.today() for local date, or datetime.And utcnow(). date() for UTC
current_date = date.
delta = current_date - start_date
print(f"Days since June 15, 2023: {delta.days}")
# Output example (run on 2025-05-22): Days since June 15, 2023: 707
JavaScript (Vanilla)
JS uses milliseconds (epoch time). Remember months are 0-indexed (June is month 5) Simple as that..
const start = new Date(2023, 5, 15); // Month 5 = June
const now = new Date(); // Current local date/time
// Set time to 00:00:00 for accurate "day" comparison
start.setHours(0,0,0,0);
now.setHours(0,0,0,0);
const diffTime = Math.abs(now - start);
const diffDays =