Ruslan

Posts: n/a

Problem with formula IF(C5="", "",NOW())

I use IF(C5="", "",NOW()) to reflect the date of entry but it changes every
time with new day..how to prevent it?
in other words, if i entered smth yesterday in C5 so that for example in c4
it shows 15/02/05 so I want C4 be the same tomorrow as well, not change C4 to
tomorrow's date!

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
Precision problem with automated formula fill-in	Erny Meyer	Excel Worksheet Functions	1	February 4th 05 01:22 PM
IF(ISNA formula problem	Brad	Excel Worksheet Functions	7	January 26th 05 03:14 PM
FIXED formula problem	MO	Excel Worksheet Functions	2	January 25th 05 04:59 PM
Formula Problem	J.C.De	New Users to Excel	1	January 21st 05 04:22 PM
Baffling formula problem	Ken Schmidt	Excel Discussion (Misc queries)	2	December 21st 04 07:52 AM

All times are GMT +1. The time now is 03:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us