One way...

A2 = some date

=A2+CHOOSE(WEEKDAY(A2),1,0,0,0,0,0,-1)

A Saturday date gets reduced to Friday's date and a Sunday date gets
advanced to Monday's date.

--
Biff
Microsoft Excel MVP


"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