Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Weekend Days solutions thank you very much to both of you
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Weekend Days solutions thank you very much to both of you
To count the number of Saturdays and Sundays...
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)5)) ....where A2 contains the start date, and B2 contains the end date. Hope this helps! In article , koob wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count weekend days with criteria | Excel Worksheet Functions | |||
changing weekend days | Setting up and Configuration of Excel | |||
Formula to Remove Weekend Days | Excel Discussion (Misc queries) | |||
add days without adding weekend | New Users to Excel | |||
Weekend days other than Sat Sun | Excel Worksheet Functions |