Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
How can I get the difference in days between 2 dates, less any Saturdays or Sundays that fall within the period, returned in A3? e.g. A1 = Start date of "5-Dec-07" A2 = Finish date of "28-Dec-07" A3 = Formula calculates days worked as "17" Cell A3 would return 17 days, i.e. 23 less the 3 Saturdays and the 3 Sundays that fall within the priod. Any help would be appreciated, Ricky. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need a way to determine the # of Saturdays in a month | Excel Worksheet Functions | |||
Count Saturdays in a List | Excel Worksheet Functions | |||
Skipping Saturdays and Sunday | Charts and Charting in Excel | |||
Calculate the number of Saturdays or Sundays between 2 dates? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions |