ben simpson wrote:
I have the formula that places a 5 in a cell at the end of each
quarter (Thanks daddylonglegs).

=IF(DAY(NOW()+1)+MOD(MONTH(NOW()),3)=1,5,"")


Now what I'm searching for is a way for the 5 to remain there thru
the end of a date range (which is easily referenced). Anyone have
any good ideas out there? Thank you in advance.....Ben

I don't understand. Care to have another go at explaining exactly what you
want?