software

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,quot;quot;)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

ben simpson wrote:
gt; I have the formula that places a 5 in a cell at the end of each
gt; quarter (Thanks daddylonglegs).
gt;
gt; =IF(DAY(NOW() 1) MOD(MONTH(NOW()),3)=1,5,quot;quot;)
gt;
gt;
gt; Now what I'm searching for is a way for the 5 to remain there thru
gt; the end of a date range (which is easily referenced). Anyone have
gt; 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?