Ask your question Report

Count Days Excluding Weekends [Solved/Closed]

Negra781 - Last answer on Feb 3, 2012 5:35am GMT
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!!!!!
Read more 

Count Days Excluding Weekends »

5 replies
Answer
+9
moins plus
Trowa Oct 12, 2009 1:20pm BST
Hi Negra,

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

Best regards,
Trowa
Akshu - Feb 3, 2012 5:35am GMT
Awesome ! I loved this and it helped me greatly.
Answer
+2
moins plus
sharpman 1122Posts May 23, 2009Registration date October 20, 2010Last seen Oct 10, 2009 3:23pm BST
I think you will find what you are looking for on this link
http://www.mrexcel.com/archive/Dates/16735.html

hope it helps
Answer
+1
moins plus
Alex Aug 23, 2010 7:20pm BST
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)
Answer
+0
moins plus
Game Start Now 79Posts January 21, 2010Registration date April 20, 2012Last seen Aug 24, 2010 5:49am BST
http://www.speedyshare.com/files/23939353/Count_Working_Days_From_Date_To_Date.xls

Here Is Your Answer Dude
Ask your question
This document entitled « Count Days Excluding Weekends » from Kioskea.net (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.
Exclusive interview for Kioskea
Paul Hermelin