Practice WEEKDAY Function Online in Excel
Watch: How to use WEEKDAY Function in Excel?
What is WEEKDAY Function?
In Excel, the WEEKDAY function returns the day of the week for a given date as a number Click here to Read Full Tutorial
What is WEEKDAY Function Syntax?
=WEEKDAY(serial_number, [return_type])
Practice 1: WEEKDAY Online Practice Excel
Click on any cell below to start practicing Weekday Function. Check Instruction how to use the Weekday Function.
- Click on cell A2 and type a date, like 01/15/2025
- Click on another empty cell, like B2, where you want to see the result.
- Type this formula:
=TEXT(WEEKDAY(A2, 11), "DDDD"). - The result will show the full name of the day for the date in A2. For example, if the date is January 15, 2025, the result will be Wednesday.
