data remaining in place

B

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
 
P

Paul Lautman

ben said:
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
Click to expand...

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