datevalue

J

JennPVito

I have a "TODAY" value that changes everyday. I want to convert that to a
"DATEVALUE" that changes with the day. I need a value that equals today that
changes with the day. I do not want the date only to change but the value of
that date as well.
 
B

Bob Phillips

That is not clear to me. What do you mean by DateValue. DateValue is a
function that converts a date string to a serial number that can be
represented as a date (TODAY() is also just a serial number represented as a
date).

If you want to see say 19-Aug-2006 instead of just 19/08/2006, just use
Format>Cells>Customise and format as dd-mmm-yyyy.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

And it is not necessary to start a new thread, continue with the old one.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top