Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS? Maybe not?
Excel2003 ...
Cell B1 contains a manually input Date (1st day of month (mm/dd/yy)) & I change it as the Months change. I need to divide a number (Cell H3) by the # of NET WORKDAYS in the month displayed in Cell B1. Thanks ... Kha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS? Maybe not?
=H3/NETWORKDAYS(DATE(YEAR(B1),MONTH(B1),1),DATE(YEAR(B 1),MONTH(B1)+1,0))
-- David Biddulph "Ken" wrote in message ... Excel2003 ... Cell B1 contains a manually input Date (1st day of month (mm/dd/yy)) & I change it as the Months change. I need to divide a number (Cell H3) by the # of NET WORKDAYS in the month displayed in Cell B1. Thanks ... Kha |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS? Maybe not?
David ... Works great ... I do not use date formulas much ... And I never
think about adding the +1 to get the end date ... Thanks for supporting the boards ... Kha "David Biddulph" wrote: =H3/NETWORKDAYS(DATE(YEAR(B1),MONTH(B1),1),DATE(YEAR(B 1),MONTH(B1)+1,0)) -- David Biddulph "Ken" wrote in message ... Excel2003 ... Cell B1 contains a manually input Date (1st day of month (mm/dd/yy)) & I change it as the Months change. I need to divide a number (Cell H3) by the # of NET WORKDAYS in the month displayed in Cell B1. Thanks ... Kha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS | Excel Worksheet Functions | |||
NETWORKDAYS = 0 | Excel Discussion (Misc queries) | |||
Networkdays | Excel Worksheet Functions | |||
Help on Networkdays | Excel Worksheet Functions | |||
NETWORKDAYS Help | Excel Worksheet Functions |