data remaining in place

[ben simpson]

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

[Paul Lautman]

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?