=A10+(WEEKDAY(A10,2)5)+(WEEKDAY(A10)6)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Nan" wrote in message
...
Is there a way that Excel can recognize if a date is a weekend and round
it
to the nearest weekday?
--
TIA, Nan