| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY resulting in #VALUE error
On Sun, 20 Apr 2008 03:44:00 -0700, Joseph
wrote: Hi, Im using the below formula: =WORKDAY(DATE(YEAR(C6),MONTH(C6),DAY(C6)),5,Holid ay) 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 I guess that one or more of the cells in the Holiday range is non numeric, e.g. you may have put some text or just a blank there by mistake. Have a check. Lars-Åke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY resulting in #VALUE error
Hi,
I checked that too....all the values in the range are dates ... Analysis tool pack is also included.... - Joseph "Lars-Ã…ke Aspelin" wrote: On Sun, 20 Apr 2008 03:44:00 -0700, Joseph wrote: Hi, Im using the below formula: =WORKDAY(DATE(YEAR(C6),MONTH(C6),DAY(C6)),5,Holid ay) 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 I guess that one or more of the cells in the Holiday range is non numeric, e.g. you may have put some text or just a blank there by mistake. Have a check. Lars-Ã…ke |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY resulting in #VALUE error
Hi,
I checked again and found that I left the header ("Holiday") also in the list. I removed that and the formula is working! Thanks a lot! - Joseph "Joseph" wrote: Hi, I checked that too....all the values in the range are dates ... Analysis tool pack is also included.... - Joseph "Lars-Ã…ke Aspelin" wrote: On Sun, 20 Apr 2008 03:44:00 -0700, Joseph wrote: Hi, Im using the below formula: =WORKDAY(DATE(YEAR(C6),MONTH(C6),DAY(C6)),5,Holid ay) 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 I guess that one or more of the cells in the Holiday range is non numeric, e.g. you may have put some text or just a blank there by mistake. Have a check. Lars-Ã…ke |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY resulting in #VALUE error
As a matter of interest, why DATE(YEAR(C6),MONTH(C6),DAY(C6)) and not just
C6 ? -- David Biddulph "Joseph" wrote in message ... Hi, I checked again and found that I left the header ("Holiday") also in the list. I removed that and the formula is working! Thanks a lot! - Joseph "Joseph" wrote: Hi, I checked that too....all the values in the range are dates ... Analysis tool pack is also included.... - Joseph "Lars-Åke Aspelin" wrote: On Sun, 20 Apr 2008 03:44:00 -0700, Joseph wrote: Hi, Im using the below formula: =WORKDAY(DATE(YEAR(C6),MONTH(C6),DAY(C6)),5,Holid ay) 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 I guess that one or more of the cells in the Holiday range is non numeric, e.g. you may have put some text or just a blank there by mistake. Have a check. Lars-Åke |
| Reply |
| 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 | |||
Linear Mode
