adjusting date

[clark haddock]

I want to know if I am able to create a coloum with dates
into an excel document and I would like for other coloums
to be affected by that coloum. Ex. if I put a job to be
orderd on 10/28 but it is not ordered until 11/01 I would
like all of the other dates that are affected to be
automaticly adjusted once I change the order date to 11/01

 

[Peo Sjoblom]

Yes..

Just refer to the cell with the order date i.e.

A2 holds the order date

assume another date would be the order date plus 3

=A2+3

that way if the date change in A2 it will change in the cell with the
function,
if it is business days you might want to check networkdays whcih will return
a date considering weekends and holidays

 

[clark haddock]

How do you set networkdays?

-----Original Message-----
Yes..

Just refer to the cell with the order date i.e.

A2 holds the order date

assume another date would be the order date plus 3

=A2+3

that way if the date change in A2 it will change in the cell with the
function,
if it is business days you might want to check networkdays whcih will return
a date considering weekends and holidays

--

Regards,

Peo Sjoblom

11/01


.

 

[Peo Sjoblom]

Sorry, the function is called workday,
networkdays return the number of workdays between 2 dates and holidays,
workday returns a date based on a start date, number of days and holidays

=WORKDAY(Start_date,days,Holidays)

can look like

=WORKDAY(A1,3,H1:H10)

where A1 holds the date, H1:H10 holds the public holidays

Note that you would need the Analysis ToolPak installed (ATP),
it comes with excel/office, to install keep the cd handy and check ATP
under tools>add-ins