Calculating Start Date without using Workday()

[cmooney78]

I am attempting to calculate the start date when the desired end date is known (Column D), and the duration to complete the work is also known (50 days, Column C). I'm using Excel 2003, and this info will be broadcast to multiple users, so using the Analysis Tool Pack is not an option. Is there a formula that mimicks WORKDAY() to complete this calculation? Thank you!

 

[barry houdini]

Do you need to exclude holidays? Assuming not you can use this "array formula" for the start date

=D2-SMALL(IF(WEEKDAY(D2-ROW(INDIRECT("1:"&C2*3)),2)<6,ROW(INDIRECT("1:"&C2*3))),C2)

confirmed with CTRL+SHIFT+ENTER

 

[cmooney78]

Thank you very much Barry. Works perfectly!