---
title: "Which function is used to determine the day of the week for a date in excel? Give example."  
description: "Which function is used to determine the day of the week for a date in excel? Give example."  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96542/which-function-is-used-to-determine-the-day-of-the-week-for-a-date-in-excel-give-example  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 1 minute  

---

# Which function is used to determine the day of the week for a date in excel? Give example.

Which [function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function) is used to determine the [day of the week](https://answers.mindstick.com/qa/46881/what-time-of-the-day-and-or-day-of-the-week-is-the-best-time-for-shopping-for-airfare) for a [date](https://www.mindstick.com/articles/55/date-validation-in-c-sharp-dot-net) in excel? Give example.

## Answers

### Answer by Hitesh Vohra

- The **WEEKDAY** function in Excel accepts a date and returns a number between 1 and 7 that represents the weekday. WEEKDAY returns 1 for Sunday and 7 for Saturday by default, although this can be changed. To check the weekday, utilise the WEEKDAY function inside other calculations.
- The WEEKDAY function accepts a date and produces a number from 1 to 7 that represents the weekday. The serial number and return type arguments are passed to the WEEKDAY function. Serial number must be a valid Excel date formatted as a serial number. Return type is a numeric code that specifies which day of the week is treated as the first.
- WEEKDAY (serial_number, [return_type])
- 1- Sunday
- 2 -Monday
- 3 -Tuesday
- 4 -Wednesday
- 5 -Thursday
- 6 -Friday
- 7 -Saturday

\

**Read More: [What is the use of NameBox in MS-Excel?](https://answers.mindstick.com/qa/96543/what-is-the-use-of-namebox-in-ms-excel)**


---

Original Source: https://answers.mindstick.com/qa/96542/which-function-is-used-to-determine-the-day-of-the-week-for-a-date-in-excel-give-example

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.