excel weekday function

[SAM]

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.

 

[Pecoflyer]

Hi,

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

Hi,
if your original cell is A1, in B1 enter =a1-1 and so fort

--
Pecoflye

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html
really IS fast

 

[Rick Rothstein]

Since you said "weekday", I'm assuming you want to skip Saturdays and
Sundays. Give this formula a try...

=WORKDAY(A1,-1)

This function is built into XL2007; for earlier versions of Excel, the
WORKDAY function is part of the Analysis ToolPak add-in so, if you don't
have this loaded, click Tools/Add Ins on the menu bar and put a check mark
next to "Analysis ToolPak". If you check the help files for this function,
you will see it has an optional 3rd argument which will allow you to skip
over holidays too.