Excel Formula: Get Monday Of Week
In Excel, you can use the WEEKDAY function to find the date of Monday of the week in the given date.
Syntaxt and Arguments
|Date: the date that you used to find the Monday of the week.|
The formula returns a value in date format.
How this formula works
To get the Monday of week of the date in cell B3, please use below formula:
Press Enter key and and drag auto fill handle over the cells that need this formula.
WEEKDAY function: gets day of the week as a number (1 to 7) from date.
- Get week number from date
The article tells you how to use the WEEKNUM function to get the week number from date in Excel.
- Get fiscal year from date
This tutorial, it provides a formula to quickly find the fiscal year from a date in Excel
- Gount days between two days
To count the number of days or months or years between two given dates will be easy in Excel after you reading this tutorial
- Create weekly date range
In this tutorial, it provides a formula to quickly get the weekly date range in Excel.
- Excel WEEKNUM Function
Returns the week number of the given date in a year
- Excel WORKDAY Function
Adds workdays to the given start date and returns a workday
- Excel WEEKDAY Function
Get day of the week as a number (1 to 7) from date
- Excel DAY Function
DAY function gets the day as a number (1 to 31) from a date
- Excel NOW Function
Get the current time and date