I'm working with date ranges. What I'm looking for is a way to have a cell
given a value on a specific date, and have it remain there thru the remainder
of the date range (confused yet?). This is what i have so far:

=IF(AND(COUNTIF(Named_Range,G12:AG13)+IF(TODAY()= AG13,0,5)),5,0)

At the end of the quarter, this adds my value of 5 into a cell, and then
removes it beyond the end of the quarter. What I need is to have the cell at
a value of 0 prior to the end of the quarter. (Totally confused now?). I
know I am. Help me please, before what little hair I have left if gone for
good.