0
0
Excelspreadsheet~8 mins

WEEKDAY and WORKDAY in Excel - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - WEEKDAY and WORKDAY
Dashboard Goal

Help a small business owner track workdays and identify weekdays for scheduling deliveries and employee shifts.

Sample Data
DateEvent
2024-06-03Order Received
2024-06-04Packaging
2024-06-05Shipping
2024-06-06Delivery
2024-06-07Follow-up
2024-06-08Rest Day
2024-06-09Rest Day
Dashboard Components
  • KPI Card: Next Workday
    Formula: =WORKDAY(TODAY(),1)
    Shows the next workday date after today, skipping weekends.
  • Table: Weekday Number
    Formula in adjacent column: =WEEKDAY(A2,2)
    Shows the weekday number for each date (Monday=1 to Sunday=7).
  • KPI Card: Total Workdays in Week
    Formula: =NETWORKDAYS(DATE(2024,6,3),DATE(2024,6,9))
    Counts workdays between June 3 and June 9, 2024, excluding weekends.
Dashboard Layout
+----------------------+-----------------------+
| Next Workday (KPI)   | Total Workdays (KPI)  |
+----------------------+-----------------------+
|                                      |
|          Date & Weekday Table        |
|                                      |
+--------------------------------------+
Interactivity

User can change the date range in the NETWORKDAYS formula to see workdays count for different weeks.

The WEEKDAY column updates automatically when dates change.

Self Check

If you change the start date in the NETWORKDAYS formula to 2024-06-05, what is the new total workdays count?

Key Result
Dashboard shows next workday, weekday numbers for dates, and total workdays in a week.