Count Days Excluding Weekends [Solved/Closed]

Negra781 - Oct 9, 2009 at 11:42 AM - 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 

5 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

Thank you, Trowa 11

Something to say? Add comment

CCM has helped 1869 users this month

Awesome ! I loved this and it helped me greatly.
sharpman 1023 Posts Saturday May 23, 2009Registration dateContributorStatus October 20, 2010 Last seen - Oct 10, 2009 at 10:23 AM
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)
Game Start Now 135 Posts Thursday January 21, 2010Registration date January 7, 2017 Last seen - Aug 24, 2010 at 12:49 AM