WEEKDAY Google Sheet Formula

Generate Google Sheet WEEKDAY Formulas in seconds

Try Formula Generator View Examples

Interactive Formula Generator

Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Upgrade to Sheet Alchemy Pro

Get advanced formulas, batch processing, and priority support

Upgrade Now

Input

Result

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Pro Features Available

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Advanced Formulas

Complex array formulas and dynamic ranges

Batch Processing

Generate multiple formulas at once

Unlimited History

Save and organize all your formulas

WEEKDAY Formula Syntax

=WEEKDAY("2023-03-15", 1)

Example Use Case

Determining the day of the week from a date

Understanding the WEEKDAY Formula

The WEEKDAY function in Excel returns a number representing the day of the week for a given date. It's a date analysis tool for day classification—like determining if dates fall on weekends or scheduling based on specific days.

WEEKDAY("2023-03-15", 1) returns 4, indicating Wednesday in the default system (1=Sunday, 7=Saturday). It takes a date and optional return_type argument, supporting various numbering systems (1/2/3/11-17/21) for different day-of-week counting conventions.

Why Use WEEKDAY?

WEEKDAY classifies dates by day—think alternate scheduling or weekend identification. Its flexible numbering systems support different international standards, making it valuable for conditional formatting, filtering, or business logic based on days of the week.

Example with Sample Data

Date, [Return Type]	Formula	Result
3/15/2023, 1	=WEEKDAY("3/15/2023", 1)	4 (Wednesday, type 1)
3/15/2023, 2	=WEEKDAY("3/15/2023", 2)	3 (Wednesday, type 2)
TODAY(), 3	=WEEKDAY(TODAY(), 3)	[Current day, Mon=1, Sun=7]

WEEKDAY identifies day position: March 15, 2023 is day 4 (Wednesday) in type 1 system. It's a weekday classifier.