IsHoliday() function  Previous topicNext topicFirst topicLast topic


IsHoliday() function

IsHoliday(argument list…)

This function tests whether a given date is a holiday. The function returns 1 if it is, or 0 otherwise. The function uses the following arguments:

Argument Description Restrictions
Date date to be tested valid Excel date number
Holidays array of holiday dates strictly ascending order. If no holiday calendar is available, set to 0.


© 1995-98 Leap of Faith Research Inc.