Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
ben simpson
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 09:09 AM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 08:05 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM


All times are GMT +1. The time now is 07:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"