Dynamic working days as a denominator

[HazemEita]

Hello!
So, I have a workflow that is using working as a denominator and I'm having an issue applying the same logic I have in excel

So, Today is 20240903 so working days considering only Sunday for us is considered a holiday, is 2

So, the number will be divided by 2 today but on next Monday denominator should be 6 and so on

I asked ChatGPT but the formula is not correct, so I need help please!!

Current formula for reference:

"[Vin Number] /
(
DateTimeDiff(DateTimeToday(), DateTimeFirstOfMonth(), 'days') + 1 -
(
Floor((DateTimeDiff(DateTimeFirstOfMonth(), DateTimeToday(), 'days')) / 7)
+ IIF(ToNumber(DateTimeFormat(DateTimeFirstOfMonth(), "%w")) = 0, 2, 10)
- IIF(ToNumber(DateTimeFormat(DateTimeToday(), "%w")) = 0, 1, 0)
)
)"

[Raj · Accepted solution]

@HazemEita 
find the workflow attached
mark done if solved.

[HazemEita]

Hi Raj thank you, i'll test it and mark solved if it works