Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I am trying to get a formula that will calculate the number of workdays (Monday to Friday) between two dates in the following format - if possible this will also take into account a specified list of holidays (non-workdays), e.g. 25/12/08, which I can specify in a list. This will always revolve around date 1 - so if date 2 is after date 1 it will be a positive number, if date 2 is before date one, it will be a negative number For example: Date 1 Date2 No of working days from date 1 Monday 2nd Feb Friday 30th Jan -1 Monday 2nd Feb Wednesday 4th Feb 2 Monday 2nd Feb Monday 9th Feb 5 Many thanks. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Work Days | Excel Discussion (Misc queries) | |||
Work Days Formula | Excel Discussion (Misc queries) | |||
work days function | Excel Worksheet Functions | |||
Net Work Days | Excel Discussion (Misc queries) | |||
Counting work days | Excel Discussion (Misc queries) |