Hi,

If i have a date, say 10/07/2009 and i want to have a series of cells next
to it that return the previous weekday, say 09/07/2009...and then if i change
the first cell, all of the corresponding cells update. Thanks everyone.

HI.
If A1 contains 10/07/2009, B1 will be :
=WORKDAY(A1,-1)
If you don't find the WORKDAY function, you must have to add the
Analysis Tool Pack add-in.
HTH
Daniel

Hi,

If i have a date, say 10/07/2009 and i want to have a series of cells next
to it that return the previous weekday, say 09/07/2009...and then if i change
the first cell, all of the corresponding cells update. Thanks everyone.

Assume cell A1 is your base date.

Enter this formula in B1 and copy across as needed:

=IF(COUNT($A1),A1-1,"")

Format as Date

--
Biff
Microsoft Excel MVP


"SAM" wrote in message
...
Hi,

If i have a date, say 10/07/2009 and i want to have a series of cells next
to it that return the previous weekday, say 09/07/2009...and then if i
change
the first cell, all of the corresponding cells update. Thanks everyone.