| Home |
| Search |
| Today's Posts |
|
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get number of days excluding Fridays in a given period
Hello,
Passed: =E4-D1+1-SUM(INT((E4-MOD(E4-{5,6},7)-D1+7)/7)) Remaining: =C1-E4-SUM(INT((C1-MOD(C1-{5,6},7)-E4+6)/7)) Source: http://sulprobil.com/html/date_formulas.html Actually, it seems to be the same as MRT's - just WEEKDAYS replaced by MOD... Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number of week days in a period of time | Excel Worksheet Functions | |||
| add number of days within a department for a given time period | Excel Worksheet Functions | |||
| Number of days in a running period | Excel Worksheet Functions | |||
| count work days excluding Fridays and Saturdays ??? | Excel Worksheet Functions | |||
| Finding number of particular days in a period | Excel Worksheet Functions | |||
Threaded Mode
