| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate workdays in a month.
Hi,
I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This is format as numbers, not date format. How can I use NETWORKDAYS in B2 to produce 22, B3,20, ie. the no. of workdays in that month. Appreciate your help. Cheers, YY |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate workdays in a month.
=NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,)-1)
"YY san." wrote: Hi, I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This is format as numbers, not date format. How can I use NETWORKDAYS in B2 to produce 22, B3,20, ie. the no. of workdays in that month. Appreciate your help. Cheers, YY |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate workdays in a month.
On Tue, 27 Oct 2009 08:45:01 -0700, YY san.
wrote: Hi, I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This is format as numbers, not date format. How can I use NETWORKDAYS in B2 to produce 22, B3,20, ie. the no. of workdays in that month. Appreciate your help. Cheers, YY B2: =NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,0)) and fill down to B13 --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate workdays in a month.
sorry
=NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,)) "muddan madhu" wrote: =NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,)-1) "YY san." wrote: Hi, I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This is format as numbers, not date format. How can I use NETWORKDAYS in B2 to produce 22, B3,20, ie. the no. of workdays in that month. Appreciate your help. Cheers, YY |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate workdays in a month.
sorry
=NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,)) "muddan madhu" wrote: =NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,)-1) "YY san." wrote: Hi, I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This is format as numbers, not date format. How can I use NETWORKDAYS in B2 to produce 22, B3,20, ie. the no. of workdays in that month. Appreciate your help. Cheers, YY |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date plus month, year, or years in workdays | Excel Discussion (Misc queries) | |||
| Amount of Workdays in a Month | Excel Worksheet Functions | |||
| Count workdays remaining in a month | Excel Discussion (Misc queries) | |||
| Dislpay count of workdays in a month? | Excel Worksheet Functions | |||
| Calculate the number of workdays between 2 dates | Excel Worksheet Functions | |||
![YY san.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
