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.


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