ExcelBanter - Complicated formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Complicated formula (https://www.excelbanter.com/excel-worksheet-functions/44528-complicated-formula.html)

sixwest

Complicated formula

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

JE McGimpsey

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!

All times are GMT +1. The time now is 12:47 PM.