I'm failing to see the merits of
=DATEVALUE(TEXT(TODAY(),"mm/dd/yy"))
This formula is essentially formatting today's date as a
text string, and then converting it back to an actual
date. Please explain.
Thanks.
Jason
-----Original Message-----
Just use =Today()
and if you still need a formula then
=DATEVALUE(TEXT(TODAY(),"mm/dd/yy"))
"Jason Morin" wrote
in message
...
Just use:
=TODAY()
HTH
Jason
Atlanta, GA
-----Original Message-----
TRYING TO FIND FRMULA FOR DATE VALUE OF CURRENT DATE
=DATEVALUE("12/29/04") WORKS,
BUT =DATEVALUE("TODAY()") DOESN'T
IS THERE A SOLUTION?
.
.
|