I have a formula that correctly returns if a date is a mon-fri, weekend or public holiday.
I need it to now determine if the day is a mon-fri, saturday, sunday or public holiday.
Can someone help me with the excel formula to achieve this please?
Code:
=IF(A11="","",IF(COUNTIF(Sheet2!$G$87:$DO$97,A11),"Public Holiday",IF(WEEKDAY(A11,2)>5,"Weekend","Mon-Fri")))
Can someone help me with the excel formula to achieve this please?