WEEKDAY Function Generator
WEEKDAY returns a number representing the day of the week for a given date. The second argument controls which day counts as 1.
Syntax
=WEEKDAY(serial_number, [return_type])Try it — generate a WEEKDAY formula
Examples
Is it a weekend?
=WEEKDAY(A2, 2)>5return_type 2: Mon=1, Sun=7. Above 5 means Sat or Sun.
Day name
=CHOOSE(WEEKDAY(A2), "Sun","Mon","Tue","Wed","Thu","Fri","Sat")Maps 1-7 to day names using CHOOSE.
TEXT alternative
=TEXT(A2, "dddd")Cleaner — formats date as full day name directly.
Tips
- ✓return_type 1 (default): Sun=1...Sat=7. return_type 2: Mon=1...Sun=7.
- ✓TEXT(date, "dddd") is usually simpler for just displaying day names.
- ✓WEEKDAY is pure number — use it for logic (weekend check, bucket assignment).
Related Formulas
WORKDAY
WORKDAY returns a date that is a given number of business days before or after a...
CHOOSE
CHOOSE returns a value from a list based on an index number. Great for mapping 1...
NETWORKDAYS
NETWORKDAYS calculates the number of working days between two dates, automatical...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free