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
|