View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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.