I need help; I have a date in column B, the formula in Column C is
=b5-14, this returns another date.

If that day falls on a Saturday or Sunday, I'd like the returned value
to be the previous Friday.

I can't figure out how to do this.

Can you help?


--
Sherry Moss
------------------------------------------------------------------------
Sherry Moss's Profile: http://www.excelforum.com/member.php...o&userid=29535
View this thread: http://www.excelforum.com/showthread...hreadid=492334