date minus one to equal previous weekday

[clong]

What is a formula I can use that will give me the date of the previous weekday from a date entered in another cell? For example, if I enter Monday's date of 4/3/06 in A1, I would like cell A2 to display Friday's date of 3/31/06.

Thanks!

 

[Aladin Akyurek]

Is it the previous workday that you are looking for? If so:

=WORKDAY(A1,-1)

 

[texasalynn]

use the workday function

=WORKDAY(E16,-1)

note: you need to have the add-in Analysis Tool-pak turned on for this function. This is a part of the Excel install but doesn't automatically get turned on

 

[clong]

Is there anyway to make this work for holidays? I will need the formula to not use Good Friday (4/14/06) as a workday. When I entered the following monday, 4/17/06 and used the WORKDAY formula, it returned 4/14/06.

Thanks!

 

[texasalynn]

the other part of the formula is to list holidays. I usually put a tab with the holidays, then point to those dates in the formula

=WORKDAY(E16,-1,Range of holidays)