saboh12617
New Member
- Joined
- May 31, 2024
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hello,
I'm a bit confused with the function workday. So i use it to find the working days of the month, Excel is configured to have saturday and sunday as weekend days.
However i realized today that, for the 1st of June 2024, ie 2024/06/01, which is a saturday
does not return monday 2024/06/03 as i would expect, but saturday 2024/06/01. Why? (i precise again that for the rest of the month the weekend days are correctly saturdays and sundays).
How can i "fix it", my aim being finding all the workdays of the month. Using Excel 2016.
I'm a bit confused with the function workday. So i use it to find the working days of the month, Excel is configured to have saturday and sunday as weekend days.
However i realized today that, for the 1st of June 2024, ie 2024/06/01, which is a saturday
Excel Formula:
=WORKDAY(DATE(2024;6;1);0)
How can i "fix it", my aim being finding all the workdays of the month. Using Excel 2016.