formula to get date Today-1 (Only working days)

Hi,

I work on financial trades sheet. I want a formula which gives 1 day before date i.e if its Fri, July 02, 2010 the formula shuld give me Thu, July 01, 2010 . The formula

PHP Code: 

=TODAY()-1 


works fine but on each monday it show Sunday's date. I want the formula to skip the weekends and show the friday's date.

This is because we work on value day- 1(vd-1) basis as the the market for trading is open from Mon to fri.

Any help is appreciated.

Thanks
Chetan

Or this:

=TODAY()+IF(WEEKDAY(TODAY(),1)>2,-1,-WEEKDAY(TODAY(),1)-1)

Thanks there, its working...