Learn how to use the WEEKDAY function in Excel to return the day of the week corresponding to a date. See the syntax, arguments, and examples of different return types.

If the Calendar property setting is Gregorian, the returned integer represents the Gregorian day of the week for the date argument. If the calendar is Hijri, the returned integer represents the Hijri day of the week for the date argument.

Select the cells that contain dates that you want to show as the days of the week. On the Home tab, click the dropdown in the Number Format list box, click More Number Formats, and then click the Number tab.

Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.

You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel.

Returns the week number of a specific date. For example, the week containing January 1 is the first week of the year, and is numbered week 1.

Returns the "Full" name of the Weekday for the number representing the 'Weekday'. Result: "Monday".

Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.

This article describes the formula syntax and how to use the WORKDAY.INTL function in Microsoft Excel. This function returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.