Working Day formula between two date

[Jeff_Hager]

Date Range Exclude Sunday AND 1/2 Saturday

Okay, take a look at the below: To get what you need, you’ll need to modify it slightly. The main change will be with the if-then-else (isWorkingDay) column. Instead of returning true, it will need to return a number based on the weekday. So the if-then-else would be: if svStartDate is empty, then null if svEndDate is empty, then null if ActualDate is after svEndDate, then null if Weekday is less than 2, then null if Weekday equals 7, then 0.5 else 1.0 And then your rollup shoul…

Excel formula Workdays

Hola @Alexey_Khrolovich There are 2 tricks to get this (one is easier than the other): [image] You must convert Glide date to a value using this format MM/dd/yyyy, you might use the Format Date plugin to achieve this quickly: [image] Later, configure Excel formula plugin using a new date column. You will get a number and not a real date value due to Workday() formula in GS works in this way. [image] Each value shown is the number of days since Dec 30, 1899 so, you have to convert…