Count Days Excluding Weekends [Solved/Closed]

- - Latest reply:  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!!!!!
See more 

4 replies

Best answer
11
Thank you
Hi Negra,

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

Best regards,
Trowa

Say "Thank you" 11

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

CCM 4525 users have said thank you to us this month

Awesome ! I loved this and it helped me greatly.
Posts
1022
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
278
2
Thank you
I think you will find what you are looking for on this link
http://www.mrexcel.com/archive/Dates/16735.html

hope it helps
1
Thank you
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
135
Registration date
Thursday January 21, 2010
Last seen
January 7, 2017
5