Patrick Foley

Posts: n/a

Today or Now functio

I have a cell that calculates the entry date of the row
eg =IF(A1630,$A$1,"No Data") In A1 I have =today()
This formula works fine but as I add a new row to the sheet the entry for
the day before changes to the current date. I want the entrys before current
entry to keep the date that was already there.

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
Count the number of dates in a range that are earlier than today.	DeborahS	Excel Worksheet Functions	1	March 9th 05 01:54 AM
TODAY function?	strazz	Excel Worksheet Functions	3	February 19th 05 05:57 PM
Excell Files attached to emails are suddenly not readable today. .	Debbie	Excel Discussion (Misc queries)	1	January 11th 05 06:34 PM
Today() or Date() function help	julisimo	Excel Discussion (Misc queries)	8	January 3rd 05 04:19 PM
Can I use TODAY Function in formula without it changing the next .	Tucson Guy	Excel Discussion (Misc queries)	1	December 19th 04 09:47 AM

All times are GMT +1. The time now is 03:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us