Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

Calculating Excel Dates Accounting for Weekends/Holidays

I am trying to create a type of "project to-do list" in Excel.
Each project has essentially the same tasks that need to be accomplished and each task should happen X number of days prior to the project due date.
I would like to be able to type in the project due date and have the required tasks have the "no later than" date assigned. (e.g. Project due date is 03/18/11; task 1 need to be done no later than 6 business days prior. Therefore the no-later than due date for the task should be 03/10/11)
The problem is that weekends and holidays are a problem. Help?!
0
greentatertot1970
Asked:
greentatertot1970
  • 3
1 Solution
 
greentatertot1970Author Commented:
0
 
greentatertot1970Author Commented:
I believe I have figured it out... thanks just the same.
0
 
greentatertot1970Author Commented:
=Workday(Start Date, X Number of Days +/-, Range of Holiday Dates)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now