Count Days Excluding Weekends [Solved/Closed]

Report
-
 Akshu -
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!!!!!

4 replies

Hi Negra,

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

Best regards,
Trowa
11
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Awesome ! I loved this and it helped me greatly.
Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
244
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)
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6