Need help with WORKDAY function

[Zandme]

I need to calculate a due date based on the number of days (including weekends); however, I need the due date to be on a workday. For example, if my project completion is due on December 1st I need to meet deadlines at various intervals prior to that. For simplicity let's have this sample...

Project completion is December 1, 2015
Customer contact needed 30 calendar days prior to the completion date but due date needs to occur on a week day.

Is this possible? The only thing I can determine with the workday function is how to calculate workdays only and not calendar days with the due date on a work day.

Thanks in advance for your help!

 

[V_Malkoti]

Try this:
=WORKDAY((A1-31),1)

[TABLE="class: grid, width: 282"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD="align: right"]1-Dec-15[/TD]
[TD="align: right"]2-Nov-15[/TD]
[/TR]
[TR]
[TD="align: right"]30-Nov-15[/TD]
[TD="align: right"]2-Nov-15[/TD]
[/TR]
[TR]
[TD="align: right"]2-Dec-15[/TD]
[TD="align: right"]2-Nov-15[/TD]
[/TR]
[TR]
[TD="align: right"]29-Nov-15[/TD]
[TD="align: right"]30-Oct-15[/TD]
[/TR]
[TR]
[TD="align: right"]30-Nov-15[/TD]
[TD="align: right"]2-Nov-15[/TD]
[/TR]
[TR]
[TD="align: right"]23-Nov-15[/TD]
[TD="align: right"]26-Oct-15[/TD]
[/TR]
[TR]
[TD="align: right"]22-Nov-15[/TD]
[TD="align: right"]23-Oct-15[/TD]
[/TR]
[TR]
[TD="align: right"]24-Nov-15[/TD]
[TD="align: right"]26-Oct-15[/TD]
[/TR]
[TR]
[TD="align: right"]25-Nov-15[/TD]
[TD="align: right"]26-Oct-15[/TD]
[/TR]
[TR]
[TD="align: right"]26-Nov-15[/TD]
[TD="align: right"]27-Oct-15[/TD]
[/TR]
[TR]
[TD="align: right"]27-Nov-15[/TD]
[TD="align: right"]28-Oct-15[/TD]
[/TR]
[TR]
[TD="align: right"]28-Nov-15[/TD]
[TD="align: right"]29-Oct-15[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Welcome to the board.

It's not exactly clear in your post what exactly you want to happen when the resulting date is on a weekend.
Do you want to return the next business day, or the previous business day?

If the result is say Saturday July 18 2015.
Do you want to return Monday the 20th, or Friday the 17th?

If you want the following monday, you can do

=WORKDAY(A1+10-1,1,Holidays)
A1 is the beginning date
10 is the number of days to add.
I know the 10-1 is silly, why not just put +9
It's to show the process of what it's doing.
It's first doing the + 10 days, and subtracting 1 day from that.
Then adding 1 business day.

If you wanted the previous friday instead, referse the signs of the 1's
=WORKDAY(A1+10+1,-1,Holidays)

Hope that helps.

 

[Zandme]

This is perfect! Thank you! I needed to make the due date the previous Friday. Thank you for the explanation of numbers. That will help me to remember this in the future. Many thanks!

 

[Jonmo1]

You're welcome.