Calendar Guides

Days Left in the Year: 47 From Nov. 14, 2026, With Formula

From Nov. 14, 2026 there are 47 days left in the year, or 48 counting today. The formula, 34 weekdays and a printable table for 2026 and leap year 2028.

An hourglass, a picture of counting how many days are left in the year
File photo of an hourglass. The days left in a year are the days in that year minus today's day number. Photo: Suohros / Wikimedia Commons, cropped, edited , Source, CC0
In this article
  1. What is the count of days left from Nov. 14, 2026?
  2. How do you calculate the days remaining in a year?
  3. Does a leap year change the days left?
  4. How do days left convert to weeks and months?
  5. How do you set up a year-end countdown?
  6. Printable: days left on the first of each month

From Saturday, Nov. 14, 2026, there are 47 days left in the year if you do not count today and 48 if you do, using the 365-day common year and the leap-year rule published by the U.S. Naval Observatory (USNO). The method works on any date: subtract today’s day number from the number of days in the year. Below: the formula, the Nov. 14 example, a table for the first of every month in 2026 and in leap year 2028, and a one-page printable of that table.

What is the count of days left from Nov. 14, 2026?

Nov. 14, 2026 is day 318 of the year: January to October add up to 304 days (31, 28, 31, 30, 31, 30, 31, 31, 30 and 31), and November adds 14 more. 2026 is a common year, so it has 365 days.

CountCalculationResult
Days left, not counting today365 - 31847 days (Nov. 15 to Dec. 31)
Days left, counting today365 - 318 + 148 days (Nov. 14 to Dec. 31)
Weekdays in the 47 daysMonday to Friday, holidays not removed34
Weekend days in the 47 days6 Saturdays and 7 Sundays13
Weeks in the 47 days47 / 76 weeks and 5 days

Nov. 14 is a Saturday, so counting today adds one more weekend day (34 weekdays and 14 weekend days in 48 days). These numbers are for Nov. 14 only; the number drops by one every day, so the method lasts longer than any single figure. For what falls inside that stretch, see our December 2026 holidays and key dates story. On the first of the month, Nov. 1 had 60 days left and Dec. 1 has 30.

How do you calculate the days remaining in a year?

Three steps cover every date.

  1. Find the day number: the count of days from Jan. 1 (day 1) up to and including today. Our guide on how to calculate the day of the year shows three ways to get it.
  2. Use 365 for a common year or 366 for a leap year. The USNO states the leap-year rule this way: years evenly divisible by 4 are leap years, with the exception of centurial years that are not evenly divisible by 400. Its examples: 1600, 2000 and 2400 are leap years; 1700, 1800, 1900 and 2100 are not.
  3. Subtract. For days left not counting today, take the days in the year minus the day number. For days left counting today, add 1.

In a spreadsheet, put the date in cell A1. Our formula for the day number uses the date function (DATE) and the year function (YEAR): =A1-DATE(YEAR(A1),1,0). Microsoft Support documents that a day value below 1 counts back from the first of the month, so a day of 0 is the last day of the prior month. For days left, the days-between function (DAYS) works: =DAYS(DATE(YEAR(A1),12,31),A1) returns the difference between Dec. 31 and A1. Microsoft Support describes its days function as returning “the number of days between two dates”, with 31-Dec-2021 minus 1-Jan-2021 giving 364, so it is a difference and does not count both ends. Add 1 to count today. For A1 = Nov. 14, 2026 the formula returns 47.

Does a leap year change the days left?

Yes, for dates before March 1. A leap year adds Feb. 29, so every date from March 1 on has a day number 1 higher than in a common year, while the days left after that date stay the same. January and February dates have one more day left in a leap year, because Feb. 29 is still ahead.

The table uses 2026 (common) and 2028 (leap). “Left” means days left after that date, not counting it; add 1 to count the date itself. Day numbers and counts are our computation from the month lengths and the USNO rule, checked two ways.

Date2026 day no.2026 left2028 day no.2028 left
Jan. 113641365
Feb. 13233332334
Mar. 16030561305
Apr. 19127492274
May 1121244122244
June 1152213153213
July 1182183183183
Aug. 1213152214152
Sept. 1244121245121
Oct. 12749127591
Nov. 13056030660
Dec. 13353033630
Dec. 3136503660

Our leap year explainer covers the rule in full. The same table works for other years: use the 2026 column for any common year and the 2028 column for any leap year.

How do days left convert to weeks and months?

Divide by 7 for weeks and keep the remainder as days: 47 days is 6 weeks and 5 days. Months do not convert cleanly, because they run 28 to 31 days; from Nov. 14 the days left cover the rest of November (16 days, Nov. 15 to 30) and all of December (31 days). The full weeks in a year are a separate question, covered in how many weeks are in a year.

The count above is calendar days, weekends included. A working-days count removes weekends and, depending on the employer, holidays. The 34 weekdays from Nov. 15 to Dec. 31 still include Thanksgiving, Christmas and any other weekday holiday, so use it as a ceiling, not as a count of days worked. Our business days for November and December 2026 story lists working days for that period.

How do you set up a year-end countdown?

A countdown is a personal planning tool, not an official calendar of holidays or work days.

  1. Pick the target date. Dec. 31 gives the days left in the year; any other date (a deadline, a trip) gives a countdown to that date using the same subtraction of day numbers.
  2. Decide the rule, counting today or not, and keep it for the whole countdown.
  3. Mark days off on a printable yearly calendar, or check the November and December pages for the weeks ahead.
  4. Cross-check against a day-of-year milestone. Our story on the 100th day of the year shows how a day number maps to a date.

Printable: days left on the first of each month

The printable is the month-start table in one sheet: 2026 (common) and 2028 (leap) day numbers and days left for the first of every month. It carries a year in its title because the days-left figures for dates after Feb. 28 are the same in every common year and in every leap year, as the table shows.

Free printable downloads

Every template is free, needs no sign-up and prints on US Letter paper. Choose PDF for printing or PNG for screens and documents.

Days Left in the Year printables

  • Printable list of days left in the year on the first of each month in 2026 and 2028

    Days Left in the Year: 2026 and 2028 Reference

    A one-page reference of the day number and days left on the first of each month in 2026 (a common year) and 2028 (a leap year).

    PDF, 1 page, US Letter

  • Printable list of days left in the year on the first of each month in 2026 and 2028, ink-saver version

    Days Left in the Year: 2026 and 2028 Reference (ink saver)

    A one-page reference of the day number and days left on the first of each month in 2026 (a common year) and 2028 (a leap year). Ink-saver version.

    PDF, 1 page, US Letter

Frequently asked questions

Do I count today when I work out the days left?

Pick one rule and say it. Not counting today is 365 (or 366) minus the day number; counting today adds 1. On Nov. 14, 2026 that is 47 or 48.

How many days are left in a leap year?

Subtract from 366. On Jan. 1, 2028 there are 365 days left after that day; on Dec. 31 there are 0. From March 1 on, the same calendar date has the same count left in a leap year and a common year.

How do I find the days until December 31?

Subtract today's day number from 365 or 366. Dec. 31 is day 365 in a common year and day 366 in a leap year, so the result is the days between today and Dec. 31, not counting today.

Are weekends included in the days left?

Yes. The days left in the year are calendar days. From Nov. 14, 2026, 13 of the 47 days are Saturdays or Sundays (6 Saturdays and 7 Sundays); the other 34 are Monday to Friday, and this count does not remove holidays.

How many weeks are left in the year?

Divide the days left by 7. From Nov. 14, 2026, 47 days is 6 full weeks and 5 days; counting today, 48 days is 6 weeks and 6 days.

Is the year countdown a business-day count?

No. It counts every calendar day. For working days, see our business days for November and December 2026.

Sources

  1. Leap Years (U.S. Naval Observatory, 2026-11-14)
  2. Date function (Microsoft Support)
  3. Days function (Microsoft Support)
  4. Date function (Google Docs Editors Help)

More in Calendar Guides

All Calendar Guides stories →
  1. How Many Weeks in 2027? 52 Weeks and 1 Day, 261 Weekdays
  2. March 2027 Calendar: Free Printable With Holidays and Moon Phases
  3. Leap Second Ends: Continuous UTC Starts May 20, 2027
  4. Net 30, 60, 90 Due Dates 2027: Jan. 1 Invoice Due Jan. 31
  5. US Time Zones: Nine Zones by Law and Where the Lines Run