Count 5 days (inc weekends) from today UNLESS today falls on a weekend...

[Upgradethishuman]

Hi guys,

I'm trying to write a formula which counts 5 days (inc weekends) from today UNLESS today falls on a weekend - then I need it to tell me the date 5 days from the next working day.

Is that possible?

Cheers in advance,

JP

 

[FormR]

Hi, welcome to the forum - maybe this:

=WORKDAY(TODAY()-1,1)+5