{
Returns true if the cDate is holiday
Based on https://gist.github.com/jameslin101/cf2860eba52a56281427
Post by OmoMicheal on Apr 23, 2021
}
Input:
cDate(numericseries);
Condition1=
cDate=ELDate(01,1,1980)
or cDate=ELDate(02,18,1980)
or cDate=ELDate(04,4,1980)
or cDate=ELDate(05,26,1980)
or cDate=ELDate(07,4,1980)
or cDate=ELDate(09,1,1980)
or cDate=ELDate(11,27,1980)
or cDate=ELDate(12,25,1980)
or cDate=ELDate(01,1,1981)
or cDate=ELDate(02,16,1981)
or cDate=ELDate(04,17,1981)
or cDate=ELDate(05,25,1981)
or cDate=ELDate(07,3,1981)
or cDate=ELDate(07,4,1981)
or cDate=ELDate(09,7,1981)
or cDate=ELDate(11,26,1981)
or cDate=ELDate(12,25,1981)
or cDate=ELDate(01,1,1982)
or cDate=ELDate(02,15,1982)
or cDate=ELDate(04,9,1982)
or cDate=ELDate(05,31,1982)
or cDate=ELDate(07,4,1982)
or cDate=ELDate(07,5,1982)
or cDate=ELDate(09,6,1982)
or cDate=ELDate(11,25,1982)
or cDate=ELDate(12,24,1982)
or cDate=ELDate(12,25,1982)
or cDate=ELDate(12,31,1982)
or cDate=ELDate(12,31,1982)
or cDate=ELDate(01,1,1983)
or cDate=ELDate(02,21,1983)
or cDate=ELDate(04,1,1983)
or cDate=ELDate(05,30,1983)
or cDate=ELDate(07,4,1983)
or cDate=ELDate(09,5,1983)
or cDate=ELDate(11,24,1983)
or cDate=ELDate(12,25,1983)
or cDate=ELDate(12,26,1983)
or cDate=ELDate(01,1,1984)
or cDate=ELDate(01,2,1984)
or cDate=ELDate(02,20,1984)
or cDate=ELDate(04,20,1984)
or cDate=ELDate(05,28,1984)
or cDate=ELDate(07,4,1984)
or cDate=ELDate(09,3,1984)
or cDate=ELDate(11,29,1984)
or cDate=ELDate(12,25,1984)
or cDate=ELDate(01,1,1985)
or cDate=ELDate(02,18,1985)
or cDate=ELDate(04,5,1985)
or cDate=ELDate(05,27,1985)
or cDate=ELDate(07,4,1985)
or cDate=ELDate(09,2,1985)
or cDate=ELDate(11,28,1985)
or cDate=ELDate(12,25,1985)
or cDate=ELDate(01,1,1986)
or cDate=ELDate(01,20,1986)
or cDate=ELDate(02,17,1986)
or cDate=ELDate(03,28,1986)
or cDate=ELDate(05,26,1986)
or cDate=ELDate(07,4,1986)
or cDate=ELDate(09,1,1986)
or cDate=ELDate(11,27,1986)
or cDate=ELDate(12,25,1986)
or cDate=ELDate(01,1,1987)
or cDate=ELDate(01,19,1987)
or cDate=ELDate(02,16,1987)
or cDate=ELDate(04,17,1987)
or cDate=ELDate(05,25,1987)
or cDate=ELDate(07,3,1987)
or cDate=ELDate(07,4,1987)
or cDate=ELDate(09,7,1987)
or cDate=ELDate(11,26,1987)
or cDate=ELDate(12,25,1987)
or cDate=ELDate(01,1,1988)
or cDate=ELDate(01,18,1988)
or cDate=ELDate(02,15,1988)
or cDate=ELDate(04,1,1988)
or cDate=ELDate(05,30,1988)
or cDate=ELDate(07,4,1988)
or cDate=ELDate(09,5,1988)
or cDate=ELDate(11,24,1988)
or cDate=ELDate(12,25,1988)
or cDate=ELDate(12,26,1988)
or cDate=ELDate(01,1,1989)
or cDate=ELDate(01,2,1989)
or cDate=ELDate(01,16,1989)
or cDate=ELDate(02,20,1989)
or cDate=ELDate(03,24,1989)
or cDate=ELDate(05,29,1989)
or cDate=ELDate(07,4,1989)
or cDate=ELDate(09,4,1989)
or cDate=ELDate(11,30,1989)
or cDate=ELDate(12,25,1989)
or cDate=ELDate(01,1,1990)
or cDate=ELDate(01,15,1990)
or cDate=ELDate(02,19,1990)
or cDate=ELDate(04,13,1990)
or cDate=ELDate(05,28,1990)
or cDate=ELDate(07,4,1990)
or cDate=ELDate(09,3,1990)
or cDate=ELDate(11,29,1990)
or cDate=ELDate(12,25,1990)
or cDate=ELDate(01,1,1991)
or cDate=ELDate(01,21,1991)
or cDate=ELDate(02,18,1991)
or cDate=ELDate(03,29,1991)
or cDate=ELDate(05,27,1991)
or cDate=ELDate(07,4,1991)
or cDate=ELDate(09,2,1991)
or cDate=ELDate(11,28,1991)
or cDate=ELDate(12,25,1991)
or cDate=ELDate(01,1,1992)
or cDate=ELDate(01,20,1992)
or cDate=ELDate(02,17,1992)
or cDate=ELDate(04,17,1992)
or cDate=ELDate(05,25,1992)
or cDate=ELDate(07,3,1992)
or cDate=ELDate(07,4,1992)
or cDate=ELDate(09,7,1992)
or cDate=ELDate(11,26,1992)
or cDate=ELDate(12,25,1992)
or cDate=ELDate(01,1,1993)
or cDate=ELDate(01,18,1993)
or cDate=ELDate(02,15,1993)
or cDate=ELDate(04,9,1993)
or cDate=ELDate(05,31,1993)
or cDate=ELDate(07,4,1993)
or cDate=ELDate(07,5,1993)
or cDate=ELDate(09,6,1993)
or cDate=ELDate(11,25,1993)
or cDate=ELDate(12,24,1993)
or cDate=ELDate(12,25,1993)
or cDate=ELDate(12,31,1993)
or cDate=ELDate(12,31,1993)
or cDate=ELDate(01,1,1994)
or cDate=ELDate(01,17,1994)
or cDate=ELDate(02,21,1994)
or cDate=ELDate(04,1,1994)
or cDate=ELDate(05,30,1994)
or cDate=ELDate(07,4,1994)
or cDate=ELDate(09,5,1994)
or cDate=ELDate(11,24,1994)
or cDate=ELDate(12,25,1994)
or cDate=ELDate(12,26,1994)
or cDate=ELDate(01,1,1995)
or cDate=ELDate(01,2,1995)
or cDate=ELDate(01,16,1995)
or cDate=ELDate(02,20,1995)
or cDate=ELDate(04,14,1995)
or cDate=ELDate(05,29,1995)
or cDate=ELDate(07,4,1995)
or cDate=ELDate(09,4,1995)
or cDate=ELDate(11,30,1995)
or cDate=ELDate(12,25,1995)
or cDate=ELDate(01,1,1996)
or cDate=ELDate(01,15,1996)
or cDate=ELDate(02,19,1996)
or cDate=ELDate(04,5,1996)
or cDate=ELDate(05,27,1996)
or cDate=ELDate(07,4,1996)
or cDate=ELDate(09,2,1996)
or cDate=ELDate(11,28,1996)
or cDate=ELDate(12,25,1996)
or cDate=ELDate(01,1,1997)
or cDate=ELDate(01,20,1997)
or cDate=ELDate(02,17,1997)
or cDate=ELDate(03,28,1997)
or cDate=ELDate(05,26,1997)
or cDate=ELDate(07,4,1997)
or cDate=ELDate(09,1,1997)
or cDate=ELDate(11,27,1997)
or cDate=ELDate(12,25,1997)
or cDate=ELDate(01,1,1998)
or cDate=ELDate(01,19,1998)
or cDate=ELDate(02,16,1998)
or cDate=ELDate(04,10,1998)
or cDate=ELDate(05,25,1998)
or cDate=ELDate(07,3,1998)
or cDate=ELDate(07,4,1998)
or cDate=ELDate(09,7,1998)
or cDate=ELDate(11,26,1998)
or cDate=ELDate(12,25,1998)
or cDate=ELDate(01,1,1999)
or cDate=ELDate(01,18,1999)
or cDate=ELDate(02,15,1999)
or cDate=ELDate(04,2,1999)
or cDate=ELDate(05,31,1999)
or cDate=ELDate(07,4,1999)
or cDate=ELDate(07,5,1999)
or cDate=ELDate(09,6,1999)
or cDate=ELDate(11,25,1999)
or cDate=ELDate(12,24,1999)
or cDate=ELDate(12,25,1999)
or cDate=ELDate(12,31,1999)
or cDate=ELDate(12,31,1999)
or cDate=ELDate(01,1,2000)
or cDate=ELDate(01,17,2000)
or cDate=ELDate(02,21,2000)
or cDate=ELDate(04,21,2000)
or cDate=ELDate(05,29,2000)
or cDate=ELDate(07,4,2000)
or cDate=ELDate(09,4,2000)
or cDate=ELDate(11,30,2000)
or cDate=ELDate(12,25,2000)
or cDate=ELDate(01,1,2001)
or cDate=ELDate(01,15,2001)
or cDate=ELDate(02,19,2001)
or cDate=ELDate(04,13,2001)
or cDate=ELDate(05,28,2001)
or cDate=ELDate(07,4,2001)
or cDate=ELDate(09,3,2001)
or cDate=ELDate(11,29,2001)
or cDate=ELDate(12,25,2001)
or cDate=ELDate(01,1,2002)
or cDate=ELDate(01,21,2002)
or cDate=ELDate(02,18,2002)
or cDate=ELDate(03,29,2002)
or cDate=ELDate(05,27,2002)
or cDate=ELDate(07,4,2002)
or cDate=ELDate(09,2,2002)
or cDate=ELDate(11,28,2002)
or cDate=ELDate(12,25,2002)
or cDate=ELDate(01,1,2003)
or cDate=ELDate(01,20,2003)
or cDate=ELDate(02,17,2003)
or cDate=ELDate(04,18,2003)
or cDate=ELDate(05,26,2003)
or cDate=ELDate(07,4,2003)
or cDate=ELDate(09,1,2003)
or cDate=ELDate(11,27,2003)
or cDate=ELDate(12,25,2003)
or cDate=ELDate(01,1,2004)
or cDate=ELDate(01,19,2004)
or cDate=ELDate(02,16,2004)
or cDate=ELDate(04,9,2004)
or cDate=ELDate(05,31,2004)
or cDate=ELDate(07,4,2004)
or cDate=ELDate(07,5,2004)
or cDate=ELDate(09,6,2004)
or cDate=ELDate(11,25,2004)
or cDate=ELDate(12,24,2004)
or cDate=ELDate(12,25,2004)
or cDate=ELDate(12,31,2004)
or cDate=ELDate(12,31,2004)
or cDate=ELDate(01,1,2005)
or cDate=ELDate(01,17,2005)
or cDate=ELDate(02,21,2005)
or cDate=ELDate(03,25,2005)
or cDate=ELDate(05,30,2005)
or cDate=ELDate(07,4,2005)
or cDate=ELDate(09,5,2005)
or cDate=ELDate(11,24,2005)
or cDate=ELDate(12,25,2005)
or cDate=ELDate(12,26,2005)
or cDate=ELDate(01,1,2006)
or cDate=ELDate(01,2,2006)
or cDate=ELDate(01,16,2006)
or cDate=ELDate(02,20,2006)
or cDate=ELDate(04,14,2006)
or cDate=ELDate(05,29,2006)
or cDate=ELDate(07,4,2006)
or cDate=ELDate(09,4,2006)
or cDate=ELDate(11,30,2006)
or cDate=ELDate(12,25,2006)
or cDate=ELDate(01,1,2007)
or cDate=ELDate(01,15,2007)
or cDate=ELDate(02,19,2007)
or cDate=ELDate(04,6,2007)
or cDate=ELDate(05,28,2007)
or cDate=ELDate(07,4,2007)
or cDate=ELDate(09,3,2007)
or cDate=ELDate(11,29,2007)
or cDate=ELDate(12,25,2007)
or cDate=ELDate(01,1,2008)
or cDate=ELDate(01,21,2008)
or cDate=ELDate(02,18,2008)
or cDate=ELDate(03,21,2008)
or cDate=ELDate(05,26,2008)
or cDate=ELDate(07,4,2008)
or cDate=ELDate(09,1,2008)
or cDate=ELDate(11,27,2008)
or cDate=ELDate(12,25,2008)
or cDate=ELDate(01,1,2009)
or cDate=ELDate(01,19,2009)
or cDate=ELDate(02,16,2009)
or cDate=ELDate(04,10,2009)
or cDate=ELDate(05,25,2009)
or cDate=ELDate(07,3,2009)
or cDate=ELDate(07,4,2009)
or cDate=ELDate(09,7,2009)
or cDate=ELDate(11,26,2009)
or cDate=ELDate(12,25,2009)
or cDate=ELDate(01,1,2010)
or cDate=ELDate(01,18,2010)
or cDate=ELDate(02,15,2010)
or cDate=ELDate(04,2,2010)
or cDate=ELDate(05,31,2010)
or cDate=ELDate(07,4,2010)
or cDate=ELDate(07,5,2010)
or cDate=ELDate(09,6,2010)
or cDate=ELDate(11,25,2010)
or cDate=ELDate(12,24,2010)
or cDate=ELDate(12,25,2010)
or cDate=ELDate(12,31,2010)
or cDate=ELDate(12,31,2010)
or cDate=ELDate(01,1,2011)
or cDate=ELDate(01,17,2011)
or cDate=ELDate(02,21,2011)
or cDate=ELDate(04,22,2011)
or cDate=ELDate(05,30,2011)
or cDate=ELDate(07,4,2011)
or cDate=ELDate(09,5,2011)
or cDate=ELDate(11,24,2011)
or cDate=ELDate(12,25,2011)
or cDate=ELDate(12,26,2011)
or cDate=ELDate(01,1,2012)
or cDate=ELDate(01,2,2012)
or cDate=ELDate(01,16,2012)
or cDate=ELDate(02,20,2012)
or cDate=ELDate(04,6,2012)
or cDate=ELDate(05,28,2012)
or cDate=ELDate(07,4,2012)
or cDate=ELDate(09,3,2012)
or cDate=ELDate(11,29,2012)
or cDate=ELDate(12,25,2012)
or cDate=ELDate(01,1,2013)
or cDate=ELDate(01,21,2013)
or cDate=ELDate(02,18,2013)
or cDate=ELDate(03,29,2013)
or cDate=ELDate(05,27,2013)
or cDate=ELDate(07,4,2013)
or cDate=ELDate(09,2,2013)
or cDate=ELDate(11,28,2013)
or cDate=ELDate(12,25,2013)
or cDate=ELDate(01,1,2014)
or cDate=ELDate(01,20,2014)
or cDate=ELDate(02,17,2014)
or cDate=ELDate(04,18,2014)
or cDate=ELDate(05,26,2014)
or cDate=ELDate(07,4,2014)
or cDate=ELDate(09,1,2014)
or cDate=ELDate(11,27,2014)
or cDate=ELDate(12,25,2014)
or cDate=ELDate(01,1,2015)
or cDate=ELDate(01,19,2015)
or cDate=ELDate(02,16,2015)
or cDate=ELDate(04,3,2015)
or cDate=ELDate(05,25,2015)
or cDate=ELDate(07,3,2015)
or cDate=ELDate(07,4,2015)
or cDate=ELDate(09,7,2015)
or cDate=ELDate(11,26,2015)
or cDate=ELDate(12,25,2015)
or cDate=ELDate(01,1,2016)
or cDate=ELDate(01,18,2016)
or cDate=ELDate(02,15,2016)
or cDate=ELDate(03,25,2016)
or cDate=ELDate(05,30,2016)
or cDate=ELDate(07,4,2016)
or cDate=ELDate(09,5,2016)
or cDate=ELDate(11,24,2016)
or cDate=ELDate(12,25,2016)
or cDate=ELDate(12,26,2016)
or cDate=ELDate(01,1,2017)
or cDate=ELDate(01,2,2017)
or cDate=ELDate(01,16,2017)
or cDate=ELDate(02,20,2017)
or cDate=ELDate(04,14,2017)
or cDate=ELDate(05,29,2017)
or cDate=ELDate(07,4,2017)
or cDate=ELDate(09,4,2017)
or cDate=ELDate(11,30,2017)
or cDate=ELDate(12,25,2017)
or cDate=ELDate(01,1,2018)
or cDate=ELDate(01,15,2018)
or cDate=ELDate(02,19,2018)
or cDate=ELDate(03,30,2018)
or cDate=ELDate(05,28,2018)
or cDate=ELDate(07,4,2018)
or cDate=ELDate(09,3,2018)
or cDate=ELDate(11,29,2018)
or cDate=ELDate(12,25,2018)
or cDate=ELDate(01,1,2019)
or cDate=ELDate(01,21,2019)
or cDate=ELDate(02,18,2019)
or cDate=ELDate(04,19,2019)
or cDate=ELDate(05,27,2019)
or cDate=ELDate(07,4,2019)
or cDate=ELDate(09,2,2019)
or cDate=ELDate(11,28,2019)
or cDate=ELDate(12,25,2019)
or cDate=ELDate(01,1,2020)
or cDate=ELDate(01,20,2020)
or cDate=ELDate(02,17,2020)
or cDate=ELDate(04,10,2020)
or cDate=ELDate(05,25,2020)
or cDate=ELDate(07,3,2020)
or cDate=ELDate(07,4,2020)
or cDate=ELDate(09,7,2020)
or cDate=ELDate(11,26,2020)
or cDate=ELDate(12,25,2020)
or cDate=ELDate(01,1,2021)
or cDate=ELDate(01,18,2021)
or cDate=ELDate(02,15,2021)
or cDate=ELDate(04,2,2021)
or cDate=ELDate(05,31,2021)
or cDate=ELDate(07,4,2021)
or cDate=ELDate(07,5,2021)
or cDate=ELDate(09,6,2021)
or cDate=ELDate(11,25,2021)
or cDate=ELDate(12,24,2021)
or cDate=ELDate(12,25,2021)
or cDate=ELDate(01,1,2022)
or cDate=ELDate(01,17,2022)
or cDate=ELDate(02,21,2022)
or cDate=ELDate(04,15,2022)
or cDate=ELDate(05,30,2022)
or cDate=ELDate(07,4,2022)
or cDate=ELDate(09,5,2022)
or cDate=ELDate(11,24,2022)
or cDate=ELDate(12,25,2022)
or cDate=ELDate(12,26,2022)
or cDate=ELDate(01,1,2023)
or cDate=ELDate(01,2,2023)
or cDate=ELDate(01,16,2023)
or cDate=ELDate(02,20,2023)
or cDate=ELDate(04,7,2023)
or cDate=ELDate(05,29,2023)
or cDate=ELDate(07,4,2023)
or cDate=ELDate(09,4,2023)
or cDate=ELDate(11,30,2023)
or cDate=ELDate(12,25,2023)
or cDate=ELDate(01,1,2024)
or cDate=ELDate(01,15,2024)
or cDate=ELDate(02,19,2024)
or cDate=ELDate(03,29,2024)
or cDate=ELDate(05,27,2024)
or cDate=ELDate(07,4,2024)
or cDate=ELDate(09,2,2024)
or cDate=ELDate(11,28,2024)
or cDate=ELDate(12,25,2024)
or cDate=ELDate(01,1,2025)
or cDate=ELDate(01,20,2025)
or cDate=ELDate(02,17,2025)
or cDate=ELDate(04,18,2025)
or cDate=ELDate(05,26,2025)
or cDate=ELDate(07,4,2025)
or cDate=ELDate(09,1,2025)
or cDate=ELDate(11,27,2025)
or cDate=ELDate(12,25,2025)
or cDate=ELDate(01,1,2026)
or cDate=ELDate(01,19,2026)
or cDate=ELDate(02,16,2026)
or cDate=ELDate(04,3,2026)
or cDate=ELDate(05,25,2026)
or cDate=ELDate(07,3,2026)
or cDate=ELDate(07,4,2026)
or cDate=ELDate(09,7,2026)
or cDate=ELDate(11,26,2026)
or cDate=ELDate(12,25,2026)
or cDate=ELDate(01,1,2027)
or cDate=ELDate(01,18,2027)
or cDate=ELDate(02,15,2027)
or cDate=ELDate(03,26,2027)
or cDate=ELDate(05,31,2027)
or cDate=ELDate(07,4,2027)
or cDate=ELDate(07,5,2027)
or cDate=ELDate(09,6,2027)
or cDate=ELDate(11,25,2027)
or cDate=ELDate(12,24,2027)
or cDate=ELDate(12,25,2027)
or cDate=ELDate(12,31,2027)
or cDate=ELDate(12,31,2027)
or cDate=ELDate(01,1,2028)
or cDate=ELDate(01,17,2028)
or cDate=ELDate(02,21,2028)
or cDate=ELDate(04,14,2028)
or cDate=ELDate(05,29,2028)
or cDate=ELDate(07,4,2028)
or cDate=ELDate(09,4,2028)
or cDate=ELDate(11,30,2028)
or cDate=ELDate(12,25,2028)
or cDate=ELDate(01,1,2029)
or cDate=ELDate(01,15,2029)
or cDate=ELDate(02,19,2029)
or cDate=ELDate(03,30,2029)
or cDate=ELDate(05,28,2029)
or cDate=ELDate(07,4,2029)
or cDate=ELDate(09,3,2029)
or cDate=ELDate(11,29,2029)
or cDate=ELDate(12,25,2029)
or cDate=ELDate(01,1,2030)
or cDate=ELDate(01,21,2030)
or cDate=ELDate(02,18,2030)
or cDate=ELDate(04,19,2030)
or cDate=ELDate(05,27,2030)
or cDate=ELDate(07,4,2030)
or cDate=ELDate(09,2,2030)
or cDate=ELDate(11,28,2030)
or cDate=ELDate(12,25,2030);
If Condition1 Then IsHoliday=true else IsHoliday=false;
