Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the WORKDAY() for a 6days working wk excluding holida
Could someone help me with below code from "Rick Rothstein (MVP - VB)" where
holidays are excluded . Many thanks, JP.F Function DateAddSixDayWorkweek(ByVal StartDate As Date, _ WorkDays As Long) As Date If Weekday(StartDate) = 1 Then StartDate = StartDate - 1 DateAddSixDayWorkweek = DateAdd("d", 7 * (WorkDays \ 6) + _ (WorkDays Mod 6) - ((WorkDays Mod 6) _ 7 - Weekday(StartDate)), StartDate) End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the WORKDAY function for a six-day working week? | Excel Worksheet Functions | |||
WOrkday function - change working days | Excel Worksheet Functions | |||
Workday calculation - not working | Excel Worksheet Functions | |||
Workday function including sat, excluding sun | Excel Worksheet Functions | |||
Workday With Weekends Excluding Holidays | Excel Worksheet Functions |