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.

SAM;413624 Wrote:
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 your original cell is A1, in B1 enter =a1-1 and so forth


--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115220

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.

--
Rick (MVP - Excel)


"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.