On 14 Nov 2005 08:50:47 -0800, "Dave O" 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