View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default how do i force an value to "jump over weekends"

Try

=WORKDAY(TODAY(),4)

Mike

"des-sa" wrote:

please help,
suppose i want to indicate to a client that his expected delivery date is
today + 4 days, but if that date falls on a saturday or sunday, it should
return the first workday thereafter. is is possible, how?
thanks