I need a little help. I want to create a spreadsheet that if given a start date will give you a forward date from a number, not counting weekends or holidays. This will be used to calculate lead times.
ex. Start date 9/5/2006 days till due 15, it would return a date of 9/26/2006.
Thanx for the help, in advance.
Last edited by rkaiser; 09-05-2006 at 09:39 AM.
Try:
=WORKDAY(A1,B1,Holidays)
where A1 houses start date
B1 houses number of elapse days
Holidays is a named range including all the holidays to account for....this is optional and excel does not auto-include holidays.
Workday() is an Analysis Toolpak addin function. You need to have it installed...Tools|Addins....Analysis Toolpak.
Will have to figure the Holiday thing out later, but Thanx for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks