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 |
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 |