Hey all! I need some help. I have already have found some solutions from this forum on how to calculate weekdays, however for my project it is just not working, I have already made the extract date and time, applied Date&Time Difference, Strings to Numbers, Rule engine and Math Formulas, I “took out the weekend days” with a rule engine but still counting them. What am I doing wrong? Math Formula: 1+($date&time diff$*5-($Posting Date $-$Clearing date $)*2)/7 Rule Engine: ($Posting Date $ = “Sunday”) AND ($Clearing date $ = “Saturday”) => -2 ($Posting Date $ = “Sunday”) OR ($Clearing date $ = “Saturday”) => -1 TRUE => 0 Math Formula: $Temp_WorkDays$+$Correction$

Calculate Weekdays with no weekends

knimediger January 20, 2022, 7:42pm 3

Hello yodata,

Maybe these threads may help you

2 Likes