=Workday, first day being weekend

[saboh12617]

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

=WORKDAY(DATE(2024;6;1);0)

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.

 

[Kerryx]

Book1
	A	B
1	01/06/2024	Saturday
2	02/06/2024	Sunday
3	03/06/2024	Monday
4	04/06/2024	Tuesday
5	05/06/2024	Wednesday
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=TEXT(A1,"dddd")

 

[saboh12617]

Excuse me but i dont think that's what i asked. Basically i am doing a list of the workdays of the month. To do so i use =Workday with the first day of the month, and an offset of days. However for an offset of 0 it returns a weekend day instead of the next weekday, as explained for the 2024/06/01.

 

[FormR]

Hi, you need to do it like this:

=WORKDAY(DATE(2024;6;1)-1;1)

With an offset of 0 your saying move 0 days to the next workday, so it doesn't move at all.

 

[saboh12617]

Indeed, perfect.
Thank you FormR.