Hi,
You can try this
=C23+CHOOSE(WEEKDAY(C23,2),3,2,1,0,-1,5,4)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"BW" wrote in message
...
If a date is a friday, I want to display the previous Thursday
(MM/DD/YYYY).
If a date is a Saturday - Thursday, I want to display the Thursday as a
date
(MM/DD/YYYY).
To illustrate, if the date is 05/28/2010, I want to display 05/27/2010.
If
the date is 05/29/2010 - 06/03/2010, I want to display 06/03/2010.
I hope this is clear.
Thank you,
BW