Forum Discussion

Mario's avatar
Mario
Qrew Member
2 years 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
2 years 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
------------------------------

  • Mario's avatar
    Mario
    Qrew Member
    2 years ago

    That worked, thank you!



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