| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find total number workdays from a range of date
I've to count total number working days from a range date; means I've to omit
off days (Friday & Saturday) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find total number workdays from a range of date
See this:
http://tinyurl.com/lml72 Biff "faisalm" wrote in message ... I've to count total number working days from a range date; means I've to omit off days (Friday & Saturday) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find total number workdays from a range of date
=NETWORKDAYS(start_date,end_date)
to include holidays, put them all in a range and add that =NETWORKDAYS(start_date,end_date,holiday_range) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "faisalm" wrote in message ... I've to count total number working days from a range date; means I've to omit off days (Friday & Saturday) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find total number workdays from a range of date
Let's do that again
=NETWORKDAYS(start_date+1,end_date+1) to include holidays, put them all in a range but add 1 to each date and use =NETWORKDAYS(start_date+1,end_date+1,holidays_rang e) This requires the Analysis Toolpak to be installed. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "faisalm" wrote in message ... I've to count total number working days from a range date; means I've to omit off days (Friday & Saturday) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop Excel interpretting a number range as a date? | Excel Discussion (Misc queries) | |||
| Find a negative number in a range | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Find last occurance of text in range | Excel Worksheet Functions | |||
| Need to find Min value based on date range entered | Excel Worksheet Functions | |||
Linear Mode
