

1. Create a UDF (User Defined Function)
To create this Function, execute the following steps
= FestivDay( (A1)
This Will Create A new UDF (User Defined Function) with name FestivDay( (A1)we Can use this As we Required. type in Excel the function As = FestivDay( A1), the UDF Comes up in small letter’s to differentiate itself from “tandard Excel Formula,if the day fall’s to National
This Code lines will create function FestivDay()
In Cell B1 Type
= FestivDay(A1)
2. Use Excel Formulas (NOT,OR)
Syntax
=NOT(OR(A1>10,B1>10,C1>10))