Complicated formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate next workday after adding calendar days to date in cell 13
Workday Formula to include date 0
Add no. of days to a workday to get new workday? 1
Calculate Future Date but don't want 6
Consecutive date calculation involving holidays 1
Nested formula using WORKDAY function 5
how do i create a formula to give a workday date? 2
Sum Workdays 5

Back
Top