On 14 Nov 2005 08:50:47 -0800, "Dave O" <[email protected]> wrote:

>I got results with this formula in C1:
>=B4-MOD(WEEKDAY(B4)+1,7)

1. You misread the same as I did. The OP wants the last Friday of the month
PRIOR to the month in *B4*.

2. The MOD function seems superfluous as WEEKDAY effectively performs a MOD
function by itself.

=B4+1-WEEKDAY(B4+2)

will return the same value as your formula.


--ron