How can I calculate dates and skip a specific weekday?
Try this:
A1 = some date
=A1+4+(WEEKDAY(A1+4)=1)
Biff
"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.
|