Forum Discussion

Qrew Member

12 months ago

Formula to determine working days in a fiscal month

I'm working on a summary report and I'm trying to count the number of weekdays in a fiscal month. I have the formula working for the calendar month, but our fiscal month is always the 22nd of the cu...

ChayceDuncan

Qrew Captain

Something like this should work:

var date t = [Scheduled Date];
var date p = AdjustMonth($t,-1);

WeekdaySub(

ToDate(Month($t) & "-21-" & Year($t)),

ToDate(Month($p) & "-22-" & Year($p))

)

------------------------------
Chayce Duncan
------------------------------

Mario

Qrew Member

12 months ago

That worked, thank you!

------------------------------
Mario
------------------------------