Uk Bank Holidays 2024 Excel Formula. There is no formula to calculate which days are bank holidays as some are assigned to special events, moved to be a particular day of the week etc. A date marked with an asterisk (or a *) is in lieu of, or a substitute for, the actual bank holiday should it fall on a weekend.
Cell a1 will always contain the 1st day of. Try to plan your transport and logistics on other.