Today's Date if none entered

  • Thread starter Thread starter J R
  • Start date Start date
J

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.
 
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.
 
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
 
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
 
Okay, I was looking right past the simple stuff. Thanks for putting me back
on track, Frank and Scott.

J.R.
 
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.
 
Back
Top