excel previous weekday function
 

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.

excel previous weekday function
 

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.

excel previous weekday function
 

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.