Hi,

Try this

=B5+CHOOSE(WEEKDAY(B5,2),4,3,2,1,0,6,5)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Michelle" wrote in message
...
I am working in a sheet where I have a date and I am trying to find the
Friday post date. I am using
=DATE(YEAR(E2),MONTH(E2),DAY(E2)-WEEKDAY(E2)+6)

It works for everyday unless the day is a Saturday. I've tried several
other
formulas (found on the discussion board) and get basically the same
results.

Michelle