Formula to determine 10 business days

  • Thread starter Thread starter OfficeManager
  • Start date Start date
O

OfficeManager

Can anyone help me with a formula to determine a date that will be 10
business days from today's date? I am working on a form and I would like
have a cell determine the due date of the product. No only do I need to
eliminate all Saturdays and Sundays, but is it possible also to eliminate all
national holidays in the formula?

Any help would be much appreciated.
TIA
 
Hi,

Select enough cells in a column somewhere that provides enough cells to
allow you to enter the dates of your public holidays and then

Insert|Name Define and call it holidays.
Enter you holiday dates in this range.
use the formula

=WORKDAY(TODAY(),10,Holidays)

Mike
 
See help on WORKDAY function from the Analysis Toolpak.


Gord Dibben MS Excel MVP
 

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

UK Business Days Formula 1
Triggering a Flag after 10 days that excludes weekends and holiday 3
Future date with six day week including holidays 1
Exclude weekends when counting days only on day 29 or 30 3
No of Days between two dates and offset formula 4
Determining the Sunday date of the third "full" weekend of a month 25
Calculating 10 Business Days from the Last Business Day of the Mon 5
Calculate the number of days to exclude Sunday & Holidays 6

Back
Top