AnsweredAssumed Answered

Calculation for how many days till deadline, but no Sundays

Question asked by DanielPinder on Feb 27, 2011
Latest reply on Feb 28, 2011 by DanielPinder

Title

Calculation for how many days till deadline, but no Sundays

Post

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?

Outcomes