Sherry Moss Wrote:
Still need help, I used the suggested formula and it didn't work for
me.

Specifically
Column B = Feb 04 06
Column C = b1-14 = Jan 21 06

This result is a Saturday. I want it to give me Friday's date = Jan 20
06.

Hi Sherry

Bob's formula worked for me, you need to change his reference to B5 to
B1 to suit your data so it should look like this

=B1-14-(WEEKDAY(B1,2)5)-(WEEKDAY(B1)=1)


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=494613