| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amount of Workdays in a Month
Greetings
Is there a way that I can calculate the amount of workdays per month, excluding weekends? I have searched - http://groups.google.com/group/micro...323305638dafa# but the calculation includes the a six (6) day workweek, I need to calculate a 5 day workweek. Thank you and I appreciate your response. Mart10 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount of Workdays in a Month
Just use =Networkdays(start_date,end_date)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mar10" wrote in message oups.com... Greetings Is there a way that I can calculate the amount of workdays per month, excluding weekends? I have searched - http://groups.google.com/group/micro...323305638dafa# but the calculation includes the a six (6) day workweek, I need to calculate a 5 day workweek. Thank you and I appreciate your response. Mart10 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount of Workdays in a Month
On May 22, 9:21 am, "Bob Phillips" wrote:
Just use =Networkdays(start_date,end_date) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mar10" wrote in message oups.com... Greetings Is there a way that I can calculate the amount of workdays per month, excluding weekends? I have searched - http://groups.google.com/group/micro...orksheet.funct... but the calculation includes the a six (6) day workweek, I need to calculate a 5 day workweek. Thank you and I appreciate your response. Mart10 Thanks Bob, this did it! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount of Workdays in a Month
Hi
With Month start in A1 =NETWORKDAYS(A1,DATE(YEAR(A1),MONTH(A1)+1,0)) Networkdays is part of the Analysis Toolpak. ToolsAddinscheck the box for Analysis Toolpak -- Regards Roger Govier "Mar10" wrote in message oups.com... Greetings Is there a way that I can calculate the amount of workdays per month, excluding weekends? I have searched - http://groups.google.com/group/micro...323305638dafa# but the calculation includes the a six (6) day workweek, I need to calculate a 5 day workweek. Thank you and I appreciate your response. Mart10 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount of Workdays in a Month
On May 22, 9:25 am, "Roger Govier"
wrote: Hi With Month start in A1 =NETWORKDAYS(A1,DATE(YEAR(A1),MONTH(A1)+1,0)) Networkdays is part of the Analysis Toolpak. ToolsAddinscheck the box for Analysis Toolpak -- Regards Roger Govier "Mar10" wrote in message oups.com... Greetings Is there a way that I can calculate the amount of workdays per month, excluding weekends? I have searched - http://groups.google.com/group/micro...orksheet.funct... but the calculation includes the a six (6) day workweek, I need to calculate a 5 day workweek. Thank you and I appreciate your response. Mart10 Thank You Roger, I needed to add the Toolpak before I could see the function! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount of Workdays in a Month
In A1 enter =DATE(2007,ROW(),1) In B1 enter =DATE(2007,ROW()+1,0) In C1 enter =NETWORKDAYS(A1,B1) Fill all three cells down... -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Mar10" wrote in message Greetings Is there a way that I can calculate the amount of workdays per month, excluding weekends? I have searched - http://groups.google.com/group/micro...323305638dafa# but the calculation includes the a six (6) day workweek, I need to calculate a 5 day workweek. Thank you and I appreciate your response. Mart10 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount of Workdays in a Month
On May 22, 9:37 am, "Jim Cone" wrote:
In A1 enter =DATE(2007,ROW(),1) In B1 enter =DATE(2007,ROW()+1,0) In C1 enter =NETWORKDAYS(A1,B1) Fill all three cells down... -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware "Mar10" wrote in message Greetings Is there a way that I can calculate the amount of workdays per month, excluding weekends? I have searched -http://groups.google.com/group/microsoft.public.excel.worksheet.funct... but the calculation includes the a six (6) day workweek, I need to calculate a 5 day workweek. Thank you and I appreciate your response.Mart10 Another option! Thank you Jim. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count workdays remaining in a month | Excel Discussion (Misc queries) | |||
| transferring amount to particular month column | Excel Worksheet Functions | |||
| Dislpay count of workdays in a month? | Excel Worksheet Functions | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Hybrid Mode
