Calculation for how many days till deadline, but no Sundays
I have a calculation that gives me the amount of days before a deadline:
Deadline - Get(currentDate) // the result is a number of days between today and the Deadline
but I need to miss out all the Sundays, because the team needs a day off. So I did this to show the amount of "workable" days:
(Deadline - Get(currentDate)) / 7 * 6
Essentially, I missed out one day per week, but this isn't going to be accurate. How could I substitute the DayOfWeek function (or something) for the cheap little arithmetic I used to achieve a more accurate result?