Replacing dates that fall on weekends

Giganews Newsgroups
Subject: Replacing dates that fall on weekends
Posted by:  p.nummin…@suomi24.fi
Date: Wed, 23 Jul 2008

In Microsoft Excel 2003, how can I automatically determine Saturdays
and Sundays in every cell that has a date in it in a selection range?
Is there a way to change Saturdays and Sundays to the preceding
Friday?

How about if I would like to define some specific dates besides
weekends that should be replaced by the nearest preceding acceptable
date?

Replies