Another Working day question!

[neway9]

Hello,

I have two cells A1 and B1, in A1 I have a date. In B1 I want that date 5 working days later (Monday to Friday).

Is this possible in 1 formula?

Thank you for your time.

[blissworks]

Just add 5 in cell B1 (=a1+5) and drag the formula

[neway9]

Hello,

Yeah, got that, but need it to be working days only.

[keithl816]

Hi neway9,

Will this work?

= WORKDAY(A1,4)

[neway9]

Yeah, that works great,

Thank you!