# Excel WEEKDAY Function

The Excel WEEKDAY function takes a date and returns a number between 1-7 representing the day of week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday. You can use the WEEKDAY function inside other formulas to check the day of week and react as needed.

**serial_number**- The date for which you want to get the day of week.**return_type**- [optional] A number representing day of week mapping scheme. Default is 1.

WEEKDAY accepts a date and returns a number between 1-7 representing the day of week for that date. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, as shown in the table below:

Result | Meaning |
---|---|

1 | Sunday |

2 | Monday |

3 | Tuesday |

4 | Wednesday |

5 | Thursday |

6 | Friday |

7 | Saturday |

WEEKDAY supports several numbering schemes. The return type argument determines which scheme used to map each day of week to a number. The return type is optional and defaults to 1. The table below shows the result and mapping associated with each return type:

Return type | Numeric result | Day mapping |
---|---|---|

none |
1-7 | Sunday-Saturday |

1 | 1-7 | Sunday-Saturday |

2 | 1-7 | Monday-Sunday |

3 | 0-6 | Monday-Sunday |

11 | 1-7 | Monday-Sunday |

12 | 1-7 | Tuesday-Monday |

13 | 1-7 | Wednesday-Tuesday |

14 | 1-7 | Thursday-Wednesday |

15 | 1-7 | Friday-Thursday |

16 | 1-7 | Saturday-Friday |

17 | 1-7 | Sunday-Saturday |

*Note: the WEEKDAY function will return a value even when the date is empty. Take care to trap this result if blank dates are possible.*

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.