Count of days excluding weekends

[jvolden]

I want to count the number of days between two dates excluding saturday and sundays. So if the strt date was thursday the 16th and the end date monday the 20th the count of days would be 2 not 4.
Thank you.
I am using Crystal Reports 11.

 

[ShortyA]

There are quite a few posts in the Business Objects:Crystal Reports1 Formulas group on this. But this should work:

local datevar startdate;
local datevar enddate;
numbervar bdays;

startdate:= {MyTable.StartDate};

enddate:= {MyTable.EndDateOrderDate};

 
bdays:= 
(
DateDiff ("d", fd, ld) - 
    DateDiff ("ww", fd, ld, crSaturday) - 
    DateDiff ("ww", fd, ld, crSunday)
)  
;

if DayOfWeek (startdate) in [1,7] then bdays := bdays -1;

bdays

[code]

Do consider public holidays though and for this I have seen a formula on Ken Hamady's website [URL unfurl="true"]www.kenhamady.com/formula.html[/URL]

ShortyA

ShortyA