Looking for Solution for Excluding Weekends in Date Motivated Formulas

[Heyna]

Hi- First post; hopefully I'll be consice and descriptive enough.
I'm working on a spreadsheet that will drive certain tasks to be don
by certain dates. I'm trying to get a fill-in date to motivate severa
cells to give set deadlines. Easy enough; I set the cell to show
date, then the motivated cells around the spreadsheet< I used an I
formula (EX: =IF(H2="","",H2+10) shows that a task must be done 1
days after initial motivation date, and the cell is formated to sho
the date. However, what I want is to show 10 WORKDAYS. The Networkday
formula will show you how many workdays are between a start and en
date, but it doesn't go in the other direction- if i have a start date
how do I show and end date motivated by a number of workdays as
formula?
Do I need to re-think my simple strategy? This is a "formal
spreadsheet"; in other wrods, it looks like a form, not just a list o
numbers or a chart.
Help, please!
Thanks, Scott (Heyna

 

[Bob Phillips]

=IF(H2="","",WORKDAY(H2,10))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

Look at the ATP function WORKDAY

=WORKDAY(start_date,number_of_days,holidays)

 

[Dave R.]

try this;

=IF(H2="","",H2+10+(10-NETWORKDAYS(H2,H2+10)))

 

[Heyna]

Thank you very much! It worked!!