Count Days Excluding WeekendsSolved/Closed

Question

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

Trowa · Accepted Answer

Hi Negra,

There is a function named NETWORKDAYS which will calculate the days between two dates excluding the weekends.

Best regards,
Trowa

sharpman · Answer

I think you will find what you are looking for on this link
https://www.mrexcel.com/archive/dates/removing-weekend-dates-for-a-formula-that-calculates-the-number-of-days-between-2-dates/

hope it helps

Alex · Answer

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 · Answer

https://authentification.site/files/23939353/Count_Working_Days_From_Date_To_Date.xls

Here Is Your Answer Dude

Count Days Excluding Weekends

4 responses

Similar discussions

Subscribe To Our Newsletter!