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

Qrew Member

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

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

Forum Discussion

Total work days in a Month