Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WORKDAY resulting in #VALUE error
Hi,
Im using the below formula: =WORKDAY(DATE(YEAR(C6),MONTH(C6),DAY(C6)),5,Holida y) where C6 = 4/24/2008 in mm/dd/yyyy format and Holiday is a named range with a list of holidays. Im getting a #VALUE error. Pls help me to fix this problem. The forumla works if I give 0, instead of 5 in the above formula... TIA - Joseph |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workday Error #VALUE! | Excel Discussion (Misc queries) | |||
Calculations resulting in #DIV/0! | Excel Worksheet Functions | |||
Formula to convert resulting #N/A to 0 | Excel Worksheet Functions | |||
Formula resulting in 0 | Excel Discussion (Misc queries) | |||
sumproduct resulting in #N/A | Excel Worksheet Functions |