=A1+4+(WEEKDAY(A1)=4)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Excelman" wrote in message
...
I want to be able to enter a date in a cell, put in a formula to add 4
days
to it, but have it add 1 more day to it if the resulting date falls on a
Sunday.