--- title: "Excel calendar 2026: week numbers and holidays, step by step | PracticeExcel" description: "Build a 2026 calendar in Excel with formulas: dates that update themselves, week numbers, weekends and holidays highlighted, and the working days in every month." canonical_url: "https://practiceexcelonline.com/learn/excel-calendar-2026" meta: "og:description": "Build a 2026 calendar in Excel with formulas: dates that update themselves, week numbers, weekends and holidays highlighted, and the working days in every month." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY2FsZW5kYXIgMjAyNjogd2VlayBudW1iZXJzIGFuZCBob2xpZGF5cywgc3RlcCBieSBzdGVw%2Cdescription_~QnVpbGQgYSAyMDI2IGNhbGVuZGFyIGluIEV4Y2VsIHdpdGggZm9ybXVsYXM6IGRhdGVzIHRoYXQgdXBkYXRlIHRoZW1zZWx2ZXMsIHdlZWsgbnVtYmVycywgd2Vla2VuZHMgYW5kIGhvbGlkYXlzIGhpZ2hsaWdodGVkLCBhbmQgdGhlIHdvcmtpbmcgZGF5cyBpbiBldmVyeSBtb250aC4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jYWxlbmRhci0yMDI2Ig%2Cs_ImKBwRsTzf3TLRpE.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Excel calendar 2026: week numbers and holidays, step by step | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY2FsZW5kYXIgMjAyNjogd2VlayBudW1iZXJzIGFuZCBob2xpZGF5cywgc3RlcCBieSBzdGVw%2Cdescription_~QnVpbGQgYSAyMDI2IGNhbGVuZGFyIGluIEV4Y2VsIHdpdGggZm9ybXVsYXM6IGRhdGVzIHRoYXQgdXBkYXRlIHRoZW1zZWx2ZXMsIHdlZWsgbnVtYmVycywgd2Vla2VuZHMgYW5kIGhvbGlkYXlzIGhpZ2hsaWdodGVkLCBhbmQgdGhlIHdvcmtpbmcgZGF5cyBpbiBldmVyeSBtb250aC4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jYWxlbmRhci0yMDI2Ig%2Cs_ImKBwRsTzf3TLRpE.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Excel calendar 2026: build your own with week numbers and holidays** Build a 2026 calendar in Excel with formulas: dates that update themselves, week numbers, weekends and holidays highlighted, and the working days in every month. By Nicolaj, founder of PracticeExcel · Updated November 2, 2026 · 12 min read A calendar in Excel is easy to make by hand: type the days of the week across the top and 1, 2, 3 and so on in the cells below. It's also easy to get wrong, and it has to be redone every month and every year. Build the calendar with formulas instead and the dates take care of themselves. Change the year in one cell and the whole calendar moves, with the right weekdays, the right week numbers, and weekends and holidays in a different color. Here you'll build a calendar for 2026 step by step: first a month with week numbers, then weekends and holidays highlighted with conditional formatting, and finally a count of working days in every month. Along the way you get the US federal holidays for 2026 and the few date rules that make the calendar right. The formulas are the same ones you practice in the [**exercises on week numbers**](https://practiceexcelonline.com/practice/week-numbers) and the [**exercises on working days**](https://practiceexcelonline.com/practice/networkdays-workday), where you write them yourself in a spreadsheet and get an answer right away. ## Dates in Excel are numbers Before the calendar, one thing is worth knowing: Excel stores a date as a number. The number counts days since January 1, 1900, so January 1, 2026 is the number 46023, and January 2, 2026 is 46024. That's why you can add 1 to a date to get the next day, and subtract two dates to get the days between them. The format only decides whether the cell shows 46023 or 1/1/2026. A calendar built with formulas is just a run of numbers that grows by 1 each day, formatted so you only see what you need. If a cell shows a number like 46023 instead of a date, the format is missing. Select the cell and choose **Short Date** from the number format list on the Home tab. Read more about dates as numbers in the [**guide to dates in Excel**](https://practiceexcelonline.com/learn/excel-dates). ## Step 1: The year in one cell Start with an empty sheet and type the year 2026 in A2. Everything else in the calendar is worked out from that cell, so next year you only type 2027. Build the first day of the month with [**DATE**](https://practiceexcelonline.com/functions/date), which makes a date from a year, a month and a day: C2=DATE(A2,1,1) | | A | B | C | | --- | --- | --- | --- | | 1 | Year | | | | 2 | 2026 | | **Jan 1, 2026** | DATE builds a date from a year, a month and a day. Change the year in A2 and the whole calendar follows. `**=DATE(A2,1,1)**` gives January 1 of the year in A2. For February, write `**=DATE(A2,2,1)**`, for March `**=DATE(A2,3,1)**` and so on. If you make one sheet per month, you can work out each month from the one before with EOMONTH instead, as you'll see further down. ## Step 2: The first day on the calendar A month calendar rarely starts on the 1st. January 2026 starts on a Thursday, so the first few boxes in the first row belong to December 2025. The first date on the calendar is the start of the week that holds the 1st. US calendars usually start the week on Sunday, and many work calendars start it on Monday. [**WEEKDAY**](https://practiceexcelonline.com/functions/weekday) gives the day of the week as a number, and its second argument decides how it counts. With 2, Monday is 1, Tuesday 2 and so on up to Sunday 7. Subtract the weekday number from the date and add 1, and you have the Monday of that week: C2=A2-WEEKDAY(A2,2)+1 | | A | B | C | | --- | --- | --- | --- | | 1 | First day | | | | 2 | Jan 1, 2026 | | **Dec 29, 2025** | January 1, 2026 is a Thursday, so WEEKDAY returns 4. Subtract 4 and add 1 and you land on Monday, December 29, 2025, where the first week of the calendar starts. The formula `**=A2-WEEKDAY(A2,2)+1**` works for every date. If the 1st is itself a Monday, WEEKDAY returns 1 and the formula gives back the same date. For a calendar that starts on Sunday, leave out the second argument: `**=A2-WEEKDAY(A2)+1**`. Without it, Sunday is 1, so the formula lands on the Sunday of the week, December 28, 2025. Practice the Monday version in the [**exercise on the Monday of the week**](https://practiceexcelonline.com/practice/week-numbers/monday-of-the-week). ## Step 3: Six weeks of dates A month takes up at most six weeks on a calendar. The calendar is a grid of seven columns and six rows, 42 days in all. Type the days of the week across B3:H3, starting with Mon or Sun depending on your choice in step 2. In Excel for Microsoft 365 you fill the whole grid with one formula in B4. [**SEQUENCE**](https://practiceexcelonline.com/functions/sequence) makes a run of numbers that grows by 1. `**=SEQUENCE(6,7,B1-WEEKDAY(B1,2)+1)**` gives six rows and seven columns of dates, starting from the first Monday on the calendar, when B1 holds the first day of the month. Format the cells with the custom number format `**d**` so you see only the day number. Here is the first week of January 2026: C2=DAY(SEQUENCE(1,7,A2)) | | A | B | C | D | E | F | G | H | I | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | 1 | Monday of week | | | | | | | | | | 2 | Dec 29, 2025 | | **29** | **30** | **31** | **1** | **2** | **3** | **4** | SEQUENCE makes seven dates in a row starting Monday, December 29, and DAY shows only the day number, as on a calendar. Here [**DAY**](https://practiceexcelonline.com/functions/day) wraps the dates so you can see the day number without changing the format. In the calendar itself it's better to keep the dates and change only the format. That way conditional formatting and lookups can still tell which date each cell is. Without SEQUENCE, because you use Excel 2019 or older, build the grid with plus 1: 1. Type the first date on the calendar in B4: `**=B1-WEEKDAY(B1,2)+1**`. 2. Type `**=B4+1**` in C4 and copy it across to H4. 3. Type `**=H4+1**` in B5, so the next row carries on from the end of the week above. 4. Type `**=B5+1**` in C5, copy across to H5, and copy all of row 5 down to row 9. The result is the same: 42 dates in a row that update when you change the year or the month. ## Step 4: The month name as a heading The heading above the calendar should say which month it is. Don't type it by hand. Let [**TEXT**](https://practiceexcelonline.com/functions/text) write it from the date in B1: C2=TEXT(A2,"mmmm yyyy") | | A | B | C | | --- | --- | --- | --- | | 1 | First day | | | | 2 | Jan 1, 2026 | | **January 2026** | TEXT with the format "mmmm yyyy" spells out the month and year, for the heading above each month. The format "mmmm" spells out the month name, and "yyyy" gives the year in four digits. For a short heading like "Jan 2026", use "mmm yyyy" instead. ## Step 5: Week numbers Week numbers are common in planning, school calendars and many workplaces, and there's a trap here. Excel has two functions for week numbers, and they don't always agree: - **WEEKNUM** follows the US system by default: weeks start on Sunday, and week 1 is the week that holds January 1. - **ISOWEEKNUM** follows the ISO system used in Europe and in a lot of international business: weeks start on Monday, and week 1 is the week that holds the first Thursday of the year. `**=WEEKNUM(A2,21)**` gives the same result as `**=ISOWEEKNUM(A2)**`. Use the one your workplace or school uses. Type `**=WEEKNUM(B4)**` or `**=ISOWEEKNUM(B4)**` in A4, to the left of the first row, and copy it down. Each row's first date gives its week number. 2026 has a special week: week 53. January 1, 2026 is a Thursday, and years that start on a Thursday get 53 weeks under the ISO system. ISO week 53 runs from Monday, December 28, 2026 to Sunday, January 3, 2027: C2=ISOWEEKNUM(A2) | | A | B | C | | --- | --- | --- | --- | | 1 | Date | | | | 2 | Dec 31, 2026 | | **53** | 2026 has 53 ISO weeks, so December 31 falls in week 53. The US system also puts it in week 53 this year. Many homemade calendars and schedules break right here, because they assume a year has 52 weeks. With a week number formula in the calendar, week 53 shows up by itself. Practice the formula in the [**exercise on week numbers**](https://practiceexcelonline.com/practice/week-numbers/isoweeknum-week-number). ## Step 6: Weekends in a different color With conditional formatting, Excel can color the weekends by itself. The rule is a formula that returns TRUE for Saturday and Sunday: C2=WEEKDAY(A2,2)>5 | | A | B | C | | --- | --- | --- | --- | | 1 | Date | | | | 2 | Jan 3, 2026 | | **TRUE** | With 2 as the second argument, Monday is 1 and Sunday is 7, so anything above 5 is a Saturday or Sunday. Saturday, January 3 gives TRUE. Here's how to add it to the calendar: 1. Select the whole grid, B4:H9, with B4 as the active cell. 2. Choose **Home > Conditional Formatting > New Rule**. 3. Choose **Use a formula to determine which cells to format**. 4. Type `**=WEEKDAY(B4,2)>5**` in the box. 5. Click **Format**, pick a light gray fill and click OK twice. The formula has to point at the top-left cell of the selection with no dollar signs. That way Excel moves the reference along for each cell, just as when you copy a formula. See more rules like this one in the [**guide to conditional formatting**](https://practiceexcelonline.com/learn/conditional-formatting-excel), and practice the test in the [**exercise on weekend or weekday**](https://practiceexcelonline.com/practice/week-numbers/weekend-or-weekday). ### Days outside the month The grid also shows the last days of the month before and the first days of the month after. Fade them with another rule on the same range: `**=MONTH(B4)<>MONTH($B$1)**`. It's TRUE when the date falls in a different month from the 1st in B1, and you can give that text a light gray color. Here B1 gets dollar signs, because every cell is compared with the same cell. ### Today A third rule can highlight today's date: `**=B4=TODAY()**`. TODAY returns today's date, so the highlight moves by itself every day. Give it a clear border or bold text so it doesn't disappear into the weekend gray. ## US federal holidays in 2026 Holidays have to be in a list before Excel can use them. Put the list somewhere of its own, such as K2:K12 or a separate sheet, with one date per cell. Here are the US federal holidays for 2026: | **Holiday** | **Date** | **Day** | | --- | --- | --- | | New Year's Day | January 1 | Thursday | | Martin Luther King Jr. Day | January 19 | Monday | | Washington's Birthday | February 16 | Monday | | Memorial Day | May 25 | Monday | | Juneteenth | June 19 | Friday | | Independence Day (observed) | July 3 | Friday | | Labor Day | September 7 | Monday | | Columbus Day | October 12 | Monday | | Veterans Day | November 11 | Wednesday | | Thanksgiving Day | November 26 | Thursday | | Christmas Day | December 25 | Friday | July 4, 2026 falls on a Saturday, so the federal holiday is observed on Friday, July 3. Put the observed date on the list, because that's the day off. Many employers don't close for every federal holiday and add others, such as the day after Thanksgiving, November 27, or Good Friday, April 3. Easter Sunday is April 5, 2026. Make the list match the days your workplace actually closes. ### Highlight the holidays on the calendar With the list in place, [**COUNTIF**](https://practiceexcelonline.com/functions/countif) checks whether a date is on it. If the count is above 0, it's a holiday: D2=COUNTIF(B2:B4,A2)>0 | | A | B | C | D | | --- | --- | --- | --- | --- | | 1 | Date | Holiday | | | | 2 | Dec 25, 2026 | Jan 1, 2026 | | **TRUE** | | 3 | | Jul 3, 2026 | | | | 4 | | Dec 25, 2026 | | | COUNTIF counts how many times the date appears in the holiday list. More than 0 means it is a holiday. On the calendar this becomes a third conditional formatting rule on B4:H9: `**=COUNTIF($K$2:$K$12,B4)>0**`. The list gets dollar signs so it stays put, and B4 gets none so it moves with the cells. Give holidays the same color as weekends, or a different one if you want to tell them apart. To show the holiday's name on the calendar, type the names in the column next to the dates, L2:L12, and look them up with XLOOKUP: `**=XLOOKUP(B4,$K$2:$K$12,$L$2:$L$12,"")**`. The fourth argument, "", leaves ordinary days blank. ## Working days in every month A calendar is often the basis for a schedule, a project or a payroll calculation, and then the number of working days is what counts. [**NETWORKDAYS**](https://practiceexcelonline.com/functions/networkdays) counts the weekdays between two dates and skips weekends and holidays: E2=NETWORKDAYS(A2,B2,C2) | | A | B | C | D | E | | --- | --- | --- | --- | --- | --- | | 1 | From | To | Holiday | | | | 2 | Jan 1, 2026 | Jan 31, 2026 | Jan 1, 2026 | | **21** | January 2026 has 22 weekdays. With New Year's Day on the holiday list, 21 working days are left. Add Martin Luther King Jr. Day and it drops to 20. The formula `**=NETWORKDAYS(A2,B2,C2)**` counts both dates. The third argument is the holiday list, and here it holds only New Year's Day. On your calendar, point it at the whole list: `**=NETWORKDAYS(B1,EOMONTH(B1,0),$K$2:$K$12)**`. [**EOMONTH**](https://practiceexcelonline.com/functions/eomonth) gives the last day of a month, so you don't have to remember whether the month has 28, 30 or 31 days: C2=EOMONTH(A2,0) | | A | B | C | | --- | --- | --- | --- | | 1 | First day | | | | 2 | Feb 1, 2026 | | **Feb 28, 2026** | EOMONTH with 0 gives the last day of the same month. February 2026 ends on the 28th. With 0 as the second argument you get the end of the same month, and with 1 the end of the next month. So the first day of the next month is `**=EOMONTH(B1,0)+1**`, and that's the formula to use when you copy the month sheet and want February to follow January. With the federal holidays, 2026 looks like this: | **Month** | **Weekdays** | **Holidays on weekdays** | **Working days** | | --- | --- | --- | --- | | January | 22 | 2 | 20 | | February | 20 | 1 | 19 | | March | 22 | 0 | 22 | | April | 22 | 0 | 22 | | May | 21 | 1 | 20 | | June | 22 | 1 | 21 | | July | 23 | 1 | 22 | | August | 21 | 0 | 21 | | September | 22 | 1 | 21 | | October | 22 | 1 | 21 | | November | 21 | 2 | 19 | | December | 23 | 1 | 22 | | Total | 261 | 11 | 250 | If your work week isn't Monday to Friday, such as four days or Sunday to Thursday, use NETWORKDAYS.INTL, where you choose which days count as the weekend. Practice the count in the [**exercise on working days**](https://practiceexcelonline.com/practice/networkdays-workday/networkdays-working-days) and the [**exercise on working days around Easter**](https://practiceexcelonline.com/practice/networkdays-workday/networkdays-holidays). ## The whole year on one sheet If you'd rather have all of 2026 as one long list than as twelve month sheets, it's even simpler. Type the headers Date, Day, Week and Holiday in A1:D1 and fill in the list: - **Date** in A2: `**=SEQUENCE(365,1,DATE(2026,1,1))**` gives all 365 days of the year in a column. In older Excel, type the first date in A2 and `**=A2+1**` in A3, then copy down to row 366. - **Day** in B2: `**=TEXT(A2,"dddd")**` gives the name of the weekday, such as Thursday. - **Week** in C2: `**=WEEKNUM(A2)**` or `**=ISOWEEKNUM(A2)**`. - **Holiday** in D2: `**=XLOOKUP(A2,$K$2:$K$12,$L$2:$L$12,"")**`. Turn the list into a table with Ctrl+T and you can filter by a week, a month or the holidays alone. It's a good start for a shift schedule, a vacation planner or a training log, because every day has its own row with room to write next to it. ## When the calendar shows something wrong When you build the calendar with formulas, the mistakes are usually the same few. These are the most common: - **Numbers like 46023 instead of dates.** The cells have no date format. Choose Short Date on the Home tab, or the custom format `**d**` to show only the day number. - **The week starts on the wrong day.** WEEKDAY counts from Sunday without a second argument and from Monday with 2. Pick the one that matches the day names across the top. - **Week numbers don't match another calendar.** One of you uses WEEKNUM and the other ISO weeks. The two often differ by one, and Sundays land in different weeks. - **Every cell gets colored, or none.** The conditional formatting formula points at a cell with dollar signs, so every cell is compared with the same one. Remove the dollar signs in front of B4. - **Holidays don't get colored.** The list holds text that looks like dates instead of real dates. If the dates sit on the left of their cells, they're text. Type them again, or build them with DATE, as in `**=DATE(2026,7,3)**`. - **#SPILL! instead of dates.** SEQUENCE needs 42 empty cells. If any of them holds something, the formula can't spill. Clear the grid so the formula can fill it. ### The calendar in Google Sheets All of this works in Google Sheets too, with the same function names: SEQUENCE, WEEKDAY, WEEKNUM and ISOWEEKNUM. You'll find conditional formatting under **Format > Conditional formatting**, where you choose **Custom formula is** and type the same formula as in Excel. One difference is worth knowing: Google Sheets shows dates in the format of the spreadsheet's locale, so set the locale under File, Settings if dates show in the wrong order. ## Print the calendar A calendar often ends up on paper. A few settings make it look right: - **Make the columns equal.** Select columns B to H and drag one of the edges, and they all get the same width. - **Set a print area.** Select the heading and the grid and choose **Page Layout > Print Area > Set Print Area**. - **Fit to one page.** Under **Page Layout**, set both Width and Height to 1 page so the whole month fits on one sheet. - **Turn the paper.** Choose Landscape under Orientation if the cells have room to write in, and Portrait if they only hold dates. ## Practice the formulas The calendar uses a small handful of date formulas: DATE to build the date, WEEKDAY for the day of the week, WEEKNUM or ISOWEEKNUM for the week number, EOMONTH for the last day of the month and NETWORKDAYS for the working days. The same formulas show up in everything from budgets to delivery dates, so they're worth knowing without looking them up. Start with [**the Monday of the week**](https://practiceexcelonline.com/practice/week-numbers/monday-of-the-week), go on to [**week numbers**](https://practiceexcelonline.com/practice/week-numbers/isoweeknum-week-number) and [**days in the month**](https://practiceexcelonline.com/practice/edate-eomonth/days-in-month), and finish with [**working days around Easter**](https://practiceexcelonline.com/practice/networkdays-workday/networkdays-holidays). Each exercise is a small spreadsheet where you write the formula yourself and find out right away whether it's right. If the calendar is for keeping track of money, see the [**guide to an Excel budget template**](https://practiceexcelonline.com/learn/excel-budget-template) too, which uses the same date formulas for bills that come quarterly or once a year. ![Nicolaj](https://practiceexcelonline.com/authors/nicolaj.webp) **About the author** ## **Nicolaj**, founder of PracticeExcel I'm a software developer, and I built PracticeExcel from scratch, including the spreadsheet itself and the engine that calculates the formulas. To make that work, I had to understand every function down to the details: how VLOOKUP behaves when a code has one space too many, why a date is really a number, and when ROUND gives a different answer than the number format. [More about Nicolaj](https://practiceexcelonline.com/about#nicolaj) ## **Practice what this guide covers** Graded exercises in a real grid, in the order the guide uses them. - [**Week numbers with ISOWEEKNUM**Week numbers and weekends →](https://practiceexcelonline.com/practice/week-numbers/isoweeknum-week-number) - [**Weekend or weekday**Week numbers and weekends →](https://practiceexcelonline.com/practice/week-numbers/weekend-or-weekday) - [**The Monday that starts the week**Week numbers and weekends →](https://practiceexcelonline.com/practice/week-numbers/monday-of-the-week) - [**Count working days with NETWORKDAYS**NETWORKDAYS, WORKDAY and WEEKDAY →](https://practiceexcelonline.com/practice/networkdays-workday/networkdays-working-days) - [**Working days around Easter**NETWORKDAYS, WORKDAY and WEEKDAY →](https://practiceexcelonline.com/practice/networkdays-workday/networkdays-holidays) - [**Days in the month with DAY and EOMONTH**EDATE and EOMONTH →](https://practiceexcelonline.com/practice/edate-eomonth/days-in-month) ### **Function pages** - [**DATE**](https://practiceexcelonline.com/functions/date) - [**WEEKDAY**](https://practiceexcelonline.com/functions/weekday) - [**SEQUENCE**](https://practiceexcelonline.com/functions/sequence) - [**DAY**](https://practiceexcelonline.com/functions/day) - [**NETWORKDAYS**](https://practiceexcelonline.com/functions/networkdays) - [**COUNTIF**](https://practiceexcelonline.com/functions/countif) - [**EOMONTH**](https://practiceexcelonline.com/functions/eomonth) - [**TEXT**](https://practiceexcelonline.com/functions/text) ## **Questions**
### How many weeks are in 2026? 2026 has 53 ISO weeks. Week 53 runs from Monday, December 28, 2026 to Sunday, January 3, 2027. In Excel, =ISOWEEKNUM(DATE(2026,12,31)) returns 53.
### How many working days are in 2026? 2026 has 261 weekdays. Take off the 11 US federal holidays, all of which fall on a weekday or are observed on one, and 250 working days are left.
### How do I get week numbers in Excel? Use =WEEKNUM(A2) for the US system, where weeks start on Sunday and week 1 holds January 1. Use =ISOWEEKNUM(A2) for the ISO system, where weeks start on Monday and week 1 holds the first Thursday of the year.
### How do I highlight weekends in an Excel calendar? Use conditional formatting with the formula =WEEKDAY(B4,2)>5, where B4 is the first date in the calendar. The formula is TRUE for Saturday and Sunday, and those cells get the color you choose.
### How do I make a calendar start on Sunday? Find the Sunday on or before the first of the month with =B1-WEEKDAY(B1)+1. Without a second argument, WEEKDAY counts Sunday as 1, so the formula lands on Sunday.
## **More guides** - [**Dates in Excel: how they work and the formulas you need**Why Excel stores dates as numbers, how to add days and months, find month-ends and working days, work out ages, and fix dates that arrive as text.](https://practiceexcelonline.com/learn/excel-dates) - [**Conditional formatting in Excel: highlight cells and rows with rules and formulas**How conditional formatting works, the built-in rules worth knowing, and the formulas that highlight whole rows, overdue dates, duplicates and anything a menu can't do.](https://practiceexcelonline.com/learn/conditional-formatting-excel) - [**Excel budget template: free download and the formulas behind it**Get a free Excel budget template and learn the formulas behind it: money left over, yearly bills per month, spending by category, balance and savings goals.](https://practiceexcelonline.com/learn/excel-budget-template) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#webpage","dateModified":"2026-11-02","datePublished":"2026-11-02","description":"Build a 2026 calendar in Excel with formulas: dates that update themselves, week numbers, weekends and holidays highlighted, and the working days in every month.","name":"Excel calendar 2026: week numbers and holidays, step by step","url":"https://practiceexcelonline.com/learn/excel-calendar-2026","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/1"},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/2"},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/3"},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/4"},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/learn/excel-calendar-2026"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel guides","item":"https://practiceexcelonline.com/learn","position":2},{"@type":"ListItem","name":"Excel calendar 2026: week numbers and holidays, step by step","position":3}]},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#article","@type":"Article","dateModified":"2026-11-02","datePublished":"2026-11-02","description":"Build a 2026 calendar in Excel with formulas: dates that update themselves, week numbers, weekends and holidays highlighted, and the working days in every month.","headline":"Excel calendar 2026: week numbers and holidays, step by step","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY2FsZW5kYXIgMjAyNjogd2VlayBudW1iZXJzIGFuZCBob2xpZGF5cywgc3RlcCBieSBzdGVw%2Cdescription_~QnVpbGQgYSAyMDI2IGNhbGVuZGFyIGluIEV4Y2VsIHdpdGggZm9ybXVsYXM6IGRhdGVzIHRoYXQgdXBkYXRlIHRoZW1zZWx2ZXMsIHdlZWsgbnVtYmVycywgd2Vla2VuZHMgYW5kIGhvbGlkYXlzIGhpZ2hsaWdodGVkLCBhbmQgdGhlIHdvcmtpbmcgZGF5cyBpbiBldmVyeSBtb250aC4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jYWxlbmRhci0yMDI2Ig%2Cs_ImKBwRsTzf3TLRpE.png","author":{"@id":"https://practiceexcelonline.com/#/schema/person/1"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How many weeks are in 2026?","acceptedAnswer":{"@type":"Answer","text":"2026 has 53 ISO weeks. Week 53 runs from Monday, December 28, 2026 to Sunday, January 3, 2027. In Excel, =ISOWEEKNUM(DATE(2026,12,31)) returns 53."}},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How many working days are in 2026?","acceptedAnswer":{"@type":"Answer","text":"2026 has 261 weekdays. Take off the 11 US federal holidays, all of which fall on a weekday or are observed on one, and 250 working days are left."}},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I get week numbers in Excel?","acceptedAnswer":{"@type":"Answer","text":"Use =WEEKNUM(A2) for the US system, where weeks start on Sunday and week 1 holds January 1. Use =ISOWEEKNUM(A2) for the ISO system, where weeks start on Monday and week 1 holds the first Thursday of the year."}},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I highlight weekends in an Excel calendar?","acceptedAnswer":{"@type":"Answer","text":"Use conditional formatting with the formula =WEEKDAY(B4,2)>5, where B4 is the first date in the calendar. The formula is TRUE for Saturday and Sunday, and those cells get the color you choose."}},{"@id":"https://practiceexcelonline.com/learn/excel-calendar-2026#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"How do I make a calendar start on Sunday?","acceptedAnswer":{"@type":"Answer","text":"Find the Sunday on or before the first of the month with =B1-WEEKDAY(B1)+1. Without a second argument, WEEKDAY counts Sunday as 1, so the formula lands on Sunday."}},{"@id":"https://practiceexcelonline.com/#/schema/person/1","@type":"Person","description":"I'm a software developer, and I built PracticeExcel from scratch, including the spreadsheet itself and the engine that calculates the formulas. To make that work, I had to understand every function down to the details: how VLOOKUP behaves when a code has one space too many, why a date is really a number, and when ROUND gives a different answer than the number format.","jobTitle":"founder of PracticeExcel","name":"Nicolaj","url":"https://practiceexcelonline.com/about#nicolaj","image":{"@id":"https://practiceexcelonline.com/#/schema/image/2"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY2FsZW5kYXIgMjAyNjogd2VlayBudW1iZXJzIGFuZCBob2xpZGF5cywgc3RlcCBieSBzdGVw%2Cdescription_~QnVpbGQgYSAyMDI2IGNhbGVuZGFyIGluIEV4Y2VsIHdpdGggZm9ybXVsYXM6IGRhdGVzIHRoYXQgdXBkYXRlIHRoZW1zZWx2ZXMsIHdlZWsgbnVtYmVycywgd2Vla2VuZHMgYW5kIGhvbGlkYXlzIGhpZ2hsaWdodGVkLCBhbmQgdGhlIHdvcmtpbmcgZGF5cyBpbiBldmVyeSBtb250aC4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jYWxlbmRhci0yMDI2Ig%2Cs_ImKBwRsTzf3TLRpE.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY2FsZW5kYXIgMjAyNjogd2VlayBudW1iZXJzIGFuZCBob2xpZGF5cywgc3RlcCBieSBzdGVw%2Cdescription_~QnVpbGQgYSAyMDI2IGNhbGVuZGFyIGluIEV4Y2VsIHdpdGggZm9ybXVsYXM6IGRhdGVzIHRoYXQgdXBkYXRlIHRoZW1zZWx2ZXMsIHdlZWsgbnVtYmVycywgd2Vla2VuZHMgYW5kIGhvbGlkYXlzIGhpZ2hsaWdodGVkLCBhbmQgdGhlIHdvcmtpbmcgZGF5cyBpbiBldmVyeSBtb250aC4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jYWxlbmRhci0yMDI2Ig%2Cs_ImKBwRsTzf3TLRpE.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/2","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/authors/nicolaj.webp","inLanguage":"en-US","url":"https://practiceexcelonline.com/authors/nicolaj.webp"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.