=startdate+30
(and format it as date)
=a1+30

And look up =workday() in xl's help.

If you're running xl2003 or below, you'll have to have the analysis toolpak
loaded. Help explains this.

Silena K-K wrote:

Hi there

I want to generate an End date by adding together a start date and a
duration - one of 30 days (including weekends and holidays) and one of 30
working days (business days only)

Eg: if my start date is 30 Jun 08 what is the finish date after 30 working
days
if my start date is 30 Jun 08 what is the finish date after 30 days

Thanks for your help, Silena

--

Dave Peterson