Date Calculations

[suet]

Hi

I have a spreadsheet that has a start date and another column tha
indicates the lead in day. I am trying to calculate the date that th
task needs to start.

Eg:
Description Start Date Lead In Days Survey Start Date
Task 1 04/09/2006 43 23/July/2006
Task 2 02/10/2006 40 23 August/2006
Task 3 09/10/2006 11 28/September/2006

The formula I have entered is: =sum(start date-Lead in Days)

However this is working it out to 7 days. I need to calculate on a
day week. I am quite unexperienced in excel but have heard o
WorkingDay function but cannot work out how to use it.

Any help most appreciated. Thanking you in advance

 

[Guest]

Hi

Try
=WORKDAY(startdate,-leadindays)
I think that WORKDAY may be part of the Analysis Toolpak add-in

Andy.

 

[suet]

Hi Andy

Thats great, The Analysis toolpak hadn't been added in.

Many thanks.

Regards
Sue