| 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 |
| 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) | |||
Threaded Mode
