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

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

=B2-CHOOSE(WEEKDAY(B2),2,3,4,5,60,1)-14

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sherry Moss"
wrote in message
...

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