Hi ronocco,

Based on B16 as the origin, you could use either:


=(DAY(B$1)<$I16)*(MOD(B$1,7)=6)*$J16
or:
=($I16<=DAY(B$1))*($I16>DAY(B$1)-7)*$J16
The first formula would output the $10.00 in column D (being the last Friday before the 10th), and the second one would output it in column E (as does your current formula).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]