| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating how many Saturdays there are between two given dates
As a Human Resources Manager, I need to calculate how many working
days leave each employee takes. As some staff work a 5-day week I have used the formula, =NETWORKDAYS(A1,B1,O1:O15) where A1 is the first day of leave and B1 is the last day of leave. O1 to O15 list public holidays which the formula then deducts. However I want to add a column for staff who work a six-day week with a formula which will count the number of Saturdays in this same period ( adding the two results will give me how many working days 6-day-a- week employees take) Can any one please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of Saturdays within a range of dates | Excel Worksheet Functions | |||
| Calculate the number of Saturdays or Sundays between 2 dates? | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| I need help calculating dates? | Excel Worksheet Functions | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Threaded Mode
