Date Timer

Ralph M · Apr 29th, 2002, 05:59 PM

I have a spread sheet and I would like to have Excel react to certain exents, if column B has 12 entered in say row 16, would I be able to have Excel see that 12, and then if for 60 days there is no more data entered in the column after that, add another 12? 60 rows later? I have a date for each row on my sheet, so I have 365 rows.
Thanks for any help in advance.

Ralph M · Apr 29th, 2002, 06:01 PM

Also, I forgot to ask, if there was some number manually added before the 60 days were up, could it reset the timer to count 60 more days??

Ralph M · Apr 30th, 2002, 09:46 AM

No one has any ideas??

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 05:59 PM	#1
Ralph M Board Regular Join Date: Apr 2002 Posts: 436	I have a spread sheet and I would like to have Excel react to certain exents, if column B has 12 entered in say row 16, would I be able to have Excel see that 12, and then if for 60 days there is no more data entered in the column after that, add another 12? 60 rows later? I have a date for each row on my sheet, so I have 365 rows. Thanks for any help in advance.

Apr 29th, 2002, 06:01 PM	#2
Ralph M Board Regular Join Date: Apr 2002 Posts: 436	Also, I forgot to ask, if there was some number manually added before the 60 days were up, could it reset the timer to count 60 more days??

Apr 30th, 2002, 09:46 AM	#3
Ralph M Board Regular Join Date: Apr 2002 Posts: 436	No one has any ideas??