## Quick Intro

Use WEEKDAY Function to get weekday number of a day for a serial number which is a represent a valid date you have supplied.

In simple words, it will return the day number ranging from 1 to 7 in a week. Let’s say if you specify 01-Feb-2017 which is Wednesday, it will return 3 in the result, the reason is Wednesday is the third day of the week.

## Syntax

**WEEKDAY(serial_number,return_type)**

**serial_number**A serial number which represents the date as per excel’s date system.**return_type**A number to specify starting and the ending day of the week to consider while getting day number.

You can use different numbers to use in as return_type as per below table.

Return Type | Remarks |
---|---|

1 | Numbers 1 (Sunday) through 7 (Saturday). |

2 | Numbers 1 (Monday) through 7 (Sunday). |

3 | Numbers 0 (Monday) through 6 (Sunday). |

11 | Numbers 1 (Monday) through 7 (Sunday). |

12 | Numbers 1 (Tuesday) through 7 (Monday). |

13 | Numbers 1 (Wednesday) through 7 (Tuesday). |

14 | Numbers 1 (Thursday) through 7 (Wednesday). |

15 | Numbers 1 (Friday) through 7 (Thursday). |

16 | Numbers 1 (Saturday) through 7 (Friday). |

17 | Numbers 1 (Sunday) through 7 (Saturday). |

## More Information on Excel WEEKDAY Function

- You can also use a date which is in textual form, a result of another function, or you can enter a date directly into the function by using double quotation marks.
- If you skip specifying return type it will take 1 as default.

## Examples

In the below example, I have used weekday function with TODAY to get dynamic weekday.

It will give you the weekday whenever current date changes. You can use this method in your dashboards to trigger some values when needs to change when weekday change.

In the below example, I have used weekday with IF to create a formula which first checks weekday of a date and return “Weekday” or “Weekend” basis on the value return from weekday function.

## Sample File

## What’s Next?

To learn more about Excel WEEKDAY Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have WEEKNUM function which is highly useful. And apart from this, I have a list of excel functions and some real life formulas examples.

Kapil Marwaha13 Feb, 17 at 5:15 pmAwesome ! Thank you for this excellent explanation.