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