George Gee

Posts: n/a

Date formula

Hi All

I would like to put today's date into a cell by entering data into another
cell, the following is what I am using now:

= IF(B3="","",TODAY())

If I open the worksheet tomorrow, then the date will change,
how do I get the date to not change?

Thanks

George Gee
--

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
date format within a cell containing a formula	Brushie76	Excel Discussion (Misc queries)	1	January 22nd 05 03:50 AM
Formula with text and reference to a date cell	[email protected]	Excel Discussion (Misc queries)	1	January 11th 05 08:15 AM
Date Formula	Robyn Bellanger	Excel Discussion (Misc queries)	2	December 17th 04 07:25 PM
Date formula	Robyn Bellanger	Excel Discussion (Misc queries)	2	December 16th 04 12:41 AM
How do I add a date formula to a cell but hide the contents with .	Emzy Wemzy	Excel Discussion (Misc queries)	2	December 12th 04 01:48 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us