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

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

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

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

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