How do I get excel to calculate what day a bank holiday will be.

for example: new years day is 01/01/YEAR

if this is saturday 01/jan the bank holiday would be monday 03/jan

This is to be a dynamic calendar and so it auto populates based on the year chosen.

Can you also tell me how to do this for august bank holiday, last monday in august.

thanks,


andy