View Single Post
  #1   Report Post  
JE McGimpsey
 
Posts: n/a
Default

one way:

=A1+15+2*(WEEKDAY(A1)=6)+(WEEKDAY(A1)=7)


n article ,
"sixwest" wrote:

I need to set the following formula but I'm not sure how to proceed:

DATE + 15 days

I can do this easily enough, but I also need to have the "15th" day fall on
a workday. (so it might actually be "+16" or "+17"). Is there a way to
include the WORKDAY formula in the basic date addition?

Thanks!