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!
|