Non Working Day Function

karraj · Mar 12th, 2002, 09:29 AM

Does anybody know a function which will check whether a given day is a weekend or a holiday.

Dave Hawley · Mar 12th, 2002, 09:39 AM

Hi Karraj

You would have to put your holiday dates into a list, say A1:20 then try:

=IF(OR(WEEKDAY(C9)=1,WEEKDAY(C9)=7,NOT(ISNA(MATCH(C9,A1:A20,0)))),"Weekend or holiday","Week day and no holiday")

With C9 holding the date to check

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 09:29 AM	#1
karraj Board Regular Join Date: Mar 2002 Posts: 76	Does anybody know a function which will check whether a given day is a weekend or a holiday.

Mar 12th, 2002, 09:39 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Karraj You would have to put your holiday dates into a list, say A1:20 then try: =IF(OR(WEEKDAY(C9)=1,WEEKDAY(C9)=7,NOT(ISNA(MATCH(C9,A1:A20,0)))),"Weekend or holiday","Week day and no holiday") With C9 holding the date to check