Forum Discussion

MichaelNapolita's avatar
MichaelNapolita
Qrew Trainee
6 years ago

Remove dates from duration if they are contained within that duration

Hello I am improving my monthly sales forecast chart - essentially it takes the gross sales from the beginning of the month up to today and divides by how many weekdays have passed so far (giving a...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Hmmm,
Let me ask this question.

You are trying to calculate the # of Working Days in a particular month not counting holidays.

Which month?

Ie is is the month if the date of the Sales Order? Or if not how can you succinctly say "which month"?