Thanks for pointing that out, Ron.

"Ron Rosenfeld" wrote:

On Wed, 24 Feb 2010 18:43:01 -0800, Matt
wrote:

JJ -

1.) Enter the dates you want to analyze in column A (ie A1 is 1/15, A2 is
1/31)
2.) Enter the following in cell B1:

=IF(WEEKDAY(A2) = 1, A2 - 2, IF(WEEKDAY(A2) = 7, A2 - 1,A2))

3.) Make sure your cells are formatted as DATE
4.) Copy and paste the formula down

In this example, Jan 29 will display in cell B2 because Jan 31 falls on a
Sunday

---

The formula works as such: Analyzes the date and returns a serial
corresponding to the Day of the Week. 1 = Sunday, 2 = Monday, etc. If the
serial is 1, then subtract 2 days from the date to get to Friday, if the
serial is 7 (for Saturday) then subtract 1 day from the date to get to
Friday, otherwise leave the date unchanged.

Note that your method does not correct for holidays.
--ron
.