Forum Discussion

JenniferSilbers's avatar
JenniferSilbers
Qrew Trainee
4 years ago

Total work days in a Month

Hello, I am trying to calculate the total work days in a month based on today's date.  Here is my formula but it is not working correctly, I am getting a total of 25 days for February and there are...
Formulas and functions
GaryBlasco's avatar
GaryBlasco
Qrew Member
4 years ago
Hi Jennifer,

Please try this out. I tested it on each month of 2021, and it looks good to me.

[Input Date] is another field, however you can replace this with any Date value.

var date firstDay = ToWeekdayN(FirstDayOfMonth([Input Date]));
var date lastDay = ToWeekdayP(LastDayOfMonth([Input Date]));
var number daysInMonth = ToDays($lastDay - $firstDay) +1;
var number lastDayName = DayOfWeek($lastDay);
var number lastWeekendOffset = If ( $lastDayName = 0, 2, $lastDayName = 6, 1, 0);
var number weekends = Floor($daysInMonth / 7);
var number weekendDays = ($weekends * 2);

$daysInMonth - $weekendDays



------------------------------
Gary Blasco
------------------------------
  • JenniferSilbers's avatar
    JenniferSilbers
    Qrew Trainee
    4 years ago

    Hi Gary,

    Thank you for the help.  I will give this a try, I already see uses for individual pieces in the formula for other formulas I have been trying to do. 

    Have a great day!



    ------------------------------
    Jennifer Silberstein
    ------------------------------