WORKDAY Google Sheet Formula

Generate Google Sheet WORKDAY 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

WORKDAY Formula Syntax

=WORKDAY("2023-03-15", 10)

Example Use Case

Calculating a date that is a specified number of working days away

Understanding the WORKDAY Formula

The WORKDAY function in Excel calculates a date that is a specified number of working days (excluding weekends and optionally holidays) away from a start date. It's a business date tool for scheduling—like determining project deadlines or delivery dates based on business days.

WORKDAY("2023-03-15", 10) returns the date 10 working days after March 15, 2023. It takes start_date, days, and optional holidays arguments, automatically skipping weekends and listed holidays—perfect for business planning or project timelines.

Why Use WORKDAY?

WORKDAY projects business dates—think delivery scheduling or task planning. Its weekend and holiday skipping ensures realistic business timelines, making it essential for project management, production scheduling, or other business date calculations.

Example with Sample Data

Start Date, Days, [Holidays]	Formula	Result
3/15/2023, 10	=WORKDAY("3/15/2023", 10)	3/29/2023
3/15/2023, -5	=WORKDAY("3/15/2023", -5)	3/8/2023
3/15/2023, 10, {"3/17/2023"}	=WORKDAY("3/15/2023", 10, {"3/17/2023"})	3/30/2023 (skips holiday)

WORKDAY calculates business dates: 10 working days after March 15 is March 29, accounting for weekends. It's a business date projector.