Forum Discussion

Mario's avatar
Mario
Qrew Member
10 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's avatar
ChayceDuncan
Qrew Captain
10 months ago

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
------------------------------