Still Need Help!

S

Sherry Moss

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.
 
P

Paul Sheppard

Sherry said:
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.
Click to expand...

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)
 
Top