How it's counted
Days are counted from today to the date, not including today.
In a spreadsheet
In Excel or Google Sheets, type =TODAY()+42 and format the cell as a date. To count from a different start date, use the date calculator.
42 days after other dates
| Starting from | 42 days later |
|---|---|
| Tue, Oct 13 (today) | Tuesday, November 24, 2026 |
| Wed, Oct 14 | Wednesday, November 25, 2026 |
| Thu, Oct 15 | Thursday, November 26, 2026 |
| Fri, Oct 16 | Friday, November 27, 2026 |
| Sat, Oct 17 | Saturday, November 28, 2026 |
| Sun, Oct 18 | Sunday, November 29, 2026 |
| Mon, Oct 19 | Monday, November 30, 2026 |
Days from today
1 day from todayWed, Oct 142 days from todayThu, Oct 153 days from todayFri, Oct 164 days from todaySat, Oct 175 days from todaySun, Oct 186 days from todayMon, Oct 197 days from todayTue, Oct 208 days from todayWed, Oct 219 days from todayThu, Oct 2210 days from todayFri, Oct 2311 days from todaySat, Oct 2412 days from todaySun, Oct 2513 days from todayMon, Oct 2614 days from todayTue, Oct 2715 days from todayWed, Oct 2816 days from todayThu, Oct 2917 days from todayFri, Oct 3018 days from todaySat, Oct 3119 days from todaySun, Nov 120 days from todayMon, Nov 221 days from todayTue, Nov 322 days from todayWed, Nov 423 days from todayThu, Nov 524 days from todayFri, Nov 625 days from todaySat, Nov 726 days from todaySun, Nov 827 days from todayMon, Nov 928 days from todayTue, Nov 1029 days from todayWed, Nov 1130 days from todayThu, Nov 1231 days from todayFri, Nov 1335 days from todayTue, Nov 1740 days from todaySun, Nov 2242 days from todayTue, Nov 2445 days from todayFri, Nov 2746 days from todaySat, Nov 2849 days from todayTue, Dec 150 days from todayWed, Dec 256 days from todayTue, Dec 860 days from todaySat, Dec 1263 days from todayTue, Dec 1570 days from todayTue, Dec 2275 days from todaySun, Dec 2777 days from todayTue, Dec 2978 days from todayWed, Dec 3084 days from todayTue, Jan 5, 202790 days from todayMon, Jan 11, 202791 days from todayTue, Jan 12, 2027100 days from todayThu, Jan 21, 2027105 days from todayTue, Jan 26, 2027112 days from todayTue, Feb 2, 2027120 days from todayWed, Feb 10, 2027140 days from todayTue, Mar 2, 2027150 days from todayFri, Mar 12, 2027180 days from todaySun, Apr 11, 2027182 days from todayTue, Apr 13, 2027200 days from todaySat, May 1, 2027240 days from todayThu, Jun 10, 2027270 days from todaySat, Jul 10, 2027300 days from todayMon, Aug 9, 2027355 days from todaySun, Oct 3, 2027360 days from todayFri, Oct 8, 2027364 days from todayTue, Oct 12, 2027365 days from todayWed, Oct 13, 2027395 days from todayFri, Nov 12, 2027500 days from todayFri, Feb 25, 2028
Frequently asked questions
What day is 42 days from today?
42 days from today is Tuesday, November 24, 2026.
What day of the week is 42 days from today?
It is a Tuesday.
What date is 42 days from now?
Tuesday, November 24, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 42 days?
42 calendar days is 6.0 weeks.
What date was 42 days ago?
Tuesday, September 1, 2026.
Does "42 days from today" include today?
No. Today is day 0, so the count starts from tomorrow (or yesterday, for dates in the past).
How do I work out 42 days from today in Excel or Google Sheets?
Type =TODAY()+42 and format the cell as a date.
How many business days are in 42 days?
From today it is 30 weekdays (Monday to Friday), before public holidays.