Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 76

Modification Time Update

Please i want to modify this formula to change when column content below it
change. "=TODAY()" or if other way to do it.

A B C
A1 Last Update 02/06/2009 03/07/2008
B2- 30% C2-40%
B3- 80% C3- 20%
B4- 45% C4- 90%

Assuming i change 40% on C2 Change to 100% today then 03/07/2008 should
automatically change to 06/24/2009. Please can anybody help me with this?
Appreciate your precious time. Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Update several file at the same time?	Bob	Excel Discussion (Misc queries)	0	June 15th 09 09:27 AM
Inserting static time that doesn't update	kefee85	Excel Discussion (Misc queries)	1	February 13th 09 08:15 PM
Time update	gusdafa	Excel Worksheet Functions	9	February 26th 08 07:02 AM
update time	jschlis	Excel Discussion (Misc queries)	2	December 27th 06 02:35 PM
Time stamp that does NOT update	Pam	Excel Worksheet Functions	0	November 3rd 05 04:32 PM

All times are GMT +1. The time now is 04:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us