Date + 60 days - avoiding weekends

[Matt_Chelmsford]

Hi,

I am struggling with a formula to calculate a date + 60 days, avoiding weekends.

A day of the 23/08/2022 + 60 days = 22/10/2022 which is Saturday, so need this to go to Monday 24th October 2022

I have tried the workday formula but this calculates 60 workdays and I end up with dates in November

Be extremely grateful for any help.

Regards

Matthew

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try

=WORKDAY(A1+59,1)