The first two methods are quite complex but the last makes this type of calculation very simple. A novel generic solution that uses a simple four argument function call to return the correct answer. By combining the DATE, CHOOSE and WEEKDAY functions.ģ. By combining the DATE, WEEKDAY and MOD functions.Ģ. Session 4 of the book suggests three different ways to solve this problem.ġ. The problem arises because months have a variable number of days and can begin on a different day each year. A common format for a public holiday is:įor example, Martin Luther King day is the third Monday in January.įinding dates such as the second Thursday in January is very simple for humans to understand but is a little more challenging for Excel.
One of the problems solved in the book is to calculate the dates of public holidays. Our Book “Excel 2019 Construction Kit #1: Calendar and Year Planner” contains many advanced date/time calculations (such as calculating the current phase of the moon from a date).
