Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |