var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Day Count
I need to populate a day count on a report. This day count is the number of business days it takes to complete a job. I know the following formula will give me the day count --
DayCount = Date - JobStartDate.
However, this day count should only consider "business days", which means it should not count weekends.
Can someone give me a hand as far as how to take weekends or business days into the formula?
I got around this problem by creating the following expression:
Working Days: [actual days]*(5/7)
NB.. you must always have Monday as a start date and Sunday as a finish date for this to work though