build business days calendar

Hello everyone,

I have the attached business days calendar with manually inserted values and every year I have to modify it manually.
There is any way (formula) to build it automatically every year?

Thank you!

I could set this up for you so that you enter the first working day of the year in A4 and then it automatically generates all the other dates - is this what you want?

Pete

this would be great

Okay, the attached file does this for you. Just put the date of the first working day of the year in cell A4 (coloured yellow, and formatted to show the year) and it will automatically adjust.

Hope this helps.

Pete

I don't understand your formulas but it works great.
Thank you very much, Pete!