ExcelBanter - data remaining in place

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - data remaining in place (https://www.excelbanter.com/excel-discussion-misc-queries/76907-data-remaining-place.html)

ben simpson

data remaining in place

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

data remaining in place

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?

All times are GMT +1. The time now is 12:49 AM.