# Count Days Excluding Weekends

Solved/Closed
Negra781 - Oct 9, 2009 at 11:42 AM
Akshu - Feb 3, 2012 at 12:35 AM
Hello,

I want to do a monthly report and I have four colums: "issue date" "pick date" "pack date" "Ship date", each cell have dates, I need a formula that helps me calculate the dates since issue date that took to be pick, pack and ship. but I need to exclude the weekends for the calculation of dates. Please help!!!!!
Related:

## 4 responses

Hi Negra,

There is a function named NETWORKDAYS which will calculate the days between two dates excluding the weekends.

Best regards,
Trowa
Awesome ! I loved this and it helped me greatly.
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Oct 10, 2009 at 10:23 AM
Rem Basic syntax

Dim d1, d2

d1 = {Orders.Order Date}

d2 = {Orders.Ship Date}

formula = DateDiff("d", d1, d2) - _

DateDiff("ww", d1, d2, crSaturday) - _

DateDiff("ww", d1, d2, crSunday)

//Crystal syntax

Local DateTimeVar d1 := {Orders.Order Date};

Local DateTimeVar d2 := {Orders.Ship Date};

DateDiff ("d", d1, d2) -

DateDiff ("ww", d1, d2, crSaturday) -

DateDiff ("ww", d1, d2, crSunday)
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 7
Aug 24, 2010 at 12:49 AM