Thread: How can I calculate dates and skip a specific weekday?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 2
Default How can I calculate dates and skip a specific weekday?
Perhaps you don't need this here but for a generic formula to add the number
of days in B1 to a date in A1, excluding Sundays

=A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3))))

Reply With QuoteReply With Quote