Excel Template for Weekly Employee Schedule: How to Build One

How-to basics · Updated November 22, 2026

The fastest way to get an Excel template for a weekly employee schedule is to open Excel and search the built-in template gallery (File > New, then type “employee schedule” in the search box) — Microsoft offers several free, pre-built options that you can download and customize immediately. If you prefer to build your own from scratch, a simple grid with days across the top and employee names down the side, plus time blocks and shift notes, takes about 15 minutes to set up.

Why Use Excel Instead of Dedicated Scheduling Software

Excel remains a popular choice for small businesses, retail shops, restaurants, and teams of 5–50 people because it is already installed on most computers, costs nothing extra, and gives you full control over formatting. Unlike online scheduling tools that charge per employee per month, Excel templates work offline and have no subscription fees. The trade-off is that Excel lacks automatic conflict detection, shift swapping, and mobile notifications — you manage those manually. For teams that just need a clear visual of who works when, a well-designed Excel template is often sufficient and far more flexible than a rigid app.

Key Components of a Weekly Schedule Template

A functional weekly schedule template should include the following elements, which you can adapt to your industry:

  • Header area: Business name, week start date, and any notes or version number.
  • Employee names: Listed vertically in the first column, ideally sorted by department or role.
  • Days of the week: Seven columns (Mon–Sun) across the top, with date rows underneath each day.
  • Shift cells: Each intersection holds a shift time (e.g., 9:00 AM – 5:00 PM) or a shorthand like “9–5” or “Close”.
  • Total hours column: A SUM formula per row to calculate each employee’s weekly hours automatically.
  • Notes or legend: A small area for codes (e.g., “O” for off, “V” for vacation, “T” for training) and manager comments.

You can also add conditional formatting to highlight weekends, overtime (hours over 40), or conflicting double-bookings — though you must set up those rules yourself.

Step-by-Step: Build a Basic Template from Scratch

If you want a template tailored exactly to your needs, follow these steps in Excel for Microsoft 365 on Windows (steps are similar on Mac, but the ribbon paths differ slightly):

  1. Open a blank workbook. In cell A1, type “Employee Schedule” and in A2 type “Week of: “.
  2. In row 4, enter the days: A4 = “Employee”, B4 = “Mon”, C4 = “Tue”, D4 = “Wed”, E4 = “Thu”, F4 = “Fri”, G4 = “Sat”, H4 = “Sun”, and I4 = “Total Hours”.
  3. In column A, rows 5–15, type employee names (or up to 10 employees).
  4. For each shift cell, enter a time range as text, e.g., “9:00 AM – 5:00 PM”. Excel treats this as text, so you cannot sum it directly. Instead, add two hidden columns per day (start and end times) if you want automatic hour totals — but for simplicity, many users just type the shift and manually compute totals.
  5. To calculate total hours automatically, use a helper approach: In column I, use a formula that counts the number of non-empty shift cells and multiplies by 8 (if all shifts are 8 hours). For example, with shifts in B5:H5, enter =COUNT(B5:H5)*8 in I5. This returns 40 if all 5 weekdays are filled, 56 if all 7 days are filled (assuming 8-hour shifts). Adjust the multiplier if your shifts vary.
  6. Format the grid: Select B5:H15, go to Home > Borders, and choose “All Borders”. Then select the header row and apply bold and a fill color via Home > Font.
  7. Freeze the top rows so they stay visible when scrolling: View > Freeze Panes > Freeze Panes (or Freeze Top Row).
  8. Save the file as an Excel Template (.xltx) by choosing File > Save As and selecting “Excel Template” from the file type dropdown. This way you can reuse it without overwriting the original.

For a more advanced version, you can use actual time values. For instance, put start time in B5 (e.g., 9:00 AM) and end time in C5 (e.g., 5:00 PM), then in D5 enter =(C5-B5)*24 to get hours as a decimal (8.0). Multiply by 24 because Excel stores times as fractions of a day. Then sum the daily hour columns for each employee.

How to Choose the Right Template

When searching for a template, consider these factors:

  • Number of employees: Templates typically support 10–30 rows. If you have more, you may need to add rows manually and adjust formulas.
  • Shift complexity: If you have rotating shifts, split shifts, or overnight shifts, look for a template with separate start/end time columns rather than a single text cell.
  • Payroll integration: Some templates include a payroll summary tab that calculates gross pay based on hourly rates. These are useful but require careful setup to avoid errors.
  • Print layout: Ensure the template fits on one page when printed. Check Print Preview (File > Print) and adjust scaling or orientation.
  • Compatibility: Most templates work in Excel 2016 and later, but if you use Excel for the web, some features (like macros) may not work. Stick to simple formulas if you share via OneDrive.

If you download a template from a third-party site, verify that it doesn’t contain macros unless you trust the source. Macros can contain harmful code. Always scan downloaded files with your antivirus before opening.

Common Problems and How to Solve Them

One frequent issue is that the total hours formula doesn’t update when you change a shift. This happens if the formula references a range that doesn’t include newly added rows. Solution: extend the range or use a dynamic reference like =SUM(B5:H5) and ensure you don’t insert rows inside the range without updating the formula.

Another problem is that time calculations return negative values for overnight shifts (e.g., 10 PM to 6 AM). To handle this, use a formula that adds 1 if the end time is less than the start time: =IF(C5<B5, (C5+1-B5)*24, (C5-B5)*24). This adds a full day to the end time, giving the correct 8 hours.

Conditional formatting to highlight weekends: Select the range B5:H15, go to Home > Conditional Formatting > New Rule > Use a formula. Enter =WEEKDAY(B$4,2)>5 (assuming row 4 contains the date, not just the day name). Set a fill color. This works because WEEKDAY with return type 2 returns 6 for Saturday and 7 for Sunday.

If you need to prevent accidental edits, protect the worksheet: Review > Protect Sheet, and set a password (remember that passwords can be removed by advanced users, so don’t rely on it for sensitive data).

Excel vs. Google Sheets for Scheduling

Google Sheets offers a similar template gallery (via Template Gallery > Work) and the advantage of real-time collaboration — multiple managers can edit the same schedule simultaneously, and employees can view it from their phones. Excel’s desktop version is more powerful for complex calculations and offline use, but sharing requires either sending files or using SharePoint/OneDrive. If you need live updates and easy sharing, Google Sheets is often better. If you need advanced formulas, pivot tables, or offline access, Excel wins. Both support the same basic scheduling functions, but Excel has more robust formatting and printing options.

Cost and Safety Considerations

Excel itself is part of Microsoft 365, which costs about $6–$10 per user per month for business plans, but if you already have Excel, the template is free. Free templates from Microsoft’s gallery are safe, but be cautious with third-party downloads — only use reputable sites and check for macros. There is no financial risk in using a template, but scheduling errors can lead to labor law violations (e.g., overtime rules) or understaffing. Always double-check that your schedule complies with local labor laws regarding rest breaks and maximum hours. For payroll accuracy, use actual time values and verify totals with a calculator before submitting.

Frequently Asked Questions

Can I make a schedule that automatically calculates weekly hours? Yes, but you need to enter start and end times as actual time values (not text). Use the formula =(end-start)*24 per shift, then sum the daily totals. If you type “9-5” as text, Excel cannot calculate it directly without extra parsing.

How do I add shift notes or employee availability? Add a separate column for notes next to each day, or use a comment (right-click cell > Insert Comment). For availability, create a second sheet listing each employee’s available days, then manually cross-check when filling the schedule.

Is there a way to prevent double-booking an employee? Excel cannot automatically detect conflicts unless you write a conditional formatting rule that highlights any cell where the same employee appears twice on the same day. For example, select the range of shift cells, go to Conditional Formatting > New Rule > Use a formula, and enter =COUNTIF($B5:$H5,B5)>1 — this highlights duplicates in the same row. It won’t catch overlaps in time, but it catches duplicate shifts.

Can I use this template on my phone? Yes, if you save it to OneDrive and open it in the Excel mobile app, or if you use Excel for the web. However, editing on a small screen is cumbersome; many managers prefer to view only on mobile and edit on a computer.

What if I need to schedule 50+ employees? Excel can handle it, but the sheet becomes unwieldy. Consider using multiple sheets (one per department) or a more structured layout with employee IDs and separate shift tables. For very large teams, dedicated scheduling software with automated optimization is worth the cost.

Does Excel have a built-in schedule template? Yes, Excel’s template gallery includes options like “Weekly employee schedule”, “Shift schedule”, and “Work schedule”. Search for “schedule” in File > New to see them. These templates include pre-set formulas and formatting, so you can start immediately.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.