| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Computation of total work days
Hello,
I have a worksheet with the following data Column A Column B Column C Start Date End Date Total Work Days Jan 1, 2007 Jan 25, 2007 I need to get an output in Column C with total work days excluding the weekends inbetween the dates given in Jan 1 - 25. Does somebody have any response to this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Computation of total work days
See NETWORKDAYS in Excel help.
-- Biff Microsoft Excel MVP "Darshan" wrote in message ... Hello, I have a worksheet with the following data Column A Column B Column C Start Date End Date Total Work Days Jan 1, 2007 Jan 25, 2007 I need to get an output in Column C with total work days excluding the weekends inbetween the dates given in Jan 1 - 25. Does somebody have any response to this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Percentage to total number of NPT Days | Excel Worksheet Functions | |||
| Total last 30 days | Excel Worksheet Functions | |||
| Running total of hours based on last 7 days | Excel Worksheet Functions | |||
| total a time column that is formatted as ddd:hh:mm:ss .ddd=days | Excel Worksheet Functions | |||
| running total for last 7 calender days | Excel Discussion (Misc queries) | |||
Linear Mode
