Today's Date if none entered

[J R]

Hello,

I'd like to have today's date entered into a cell automatically if nothing
else has been entered, but when I try to do this with normal functions I am
warned that it is "volitile".

Any ideas are appreciated.

TIA,
J.R.

 

[Frank Kabel]

Hi
if you like to create a timestamp, you can't use formulas (as they will
change after you reopen your workbook). Have a look at
http://www.mcgimpsey.com/excel/timestamp.html
for some solutions. You may use the worksheet_change procedure

Frank

 

[J R]

Thanks Frank,

I'm not actually looking for a timestamp, rather something that will change
with time. I have a row (L) that receives a date when some action is taken.
I'm using the following function

=IF(ISBLANK(L3),"",DATEDIF(C3,L3,"d"))

to compute the number of days from notification (C3) to resolution (L3). If
the problem has not been resolved, I want to calculate the number of days
from notification (C3) to the present date (TODAY).

Thanks again,
J.R.

 

[Scott]

Hi J.R.!
I'm pretty sure you can just put =TODAY() in the cell and
it will automatically put in the current day. If you
change the file tomorrow, the date will update. After
=TODAY() is there, you can always type whatever date you
want over the code, but then it won't update.

Scott

 

[Frank Kabel]

Hi
then just use the function TODAY(). This will change for each day
automatically. Just keep in mind the following example:
- your issue is solved today (02/11/04)
- the notifaction date in C2 is 02/09/04
the formula TODAY()-C2 will evaluate to 2.

Thats fine but if you will open the worksheet tomorrow again, the above
formula will evaluate to 3 (as TODAY() will evaluate to 02/12/04)
So this was the reason I suggested using a kind of timestamp that will
fix the date

Frank

Frank

 

[J R]

Okay, I was looking right past the simple stuff. Thanks for putting me back
on track, Frank and Scott.

J.R.

 

[jake]

Try entering the following formula in the cell you want
the date to appear, after selecting the formatting option
for the cell. Enter, =TEXT(TODAY(),"mm-dd-yyy") that
should place the date in the cell for you.