DATEVALUE OF CURRENT DATE
 

TRYING TO FIND FRMULA FOR DATE VALUE OF CURRENT DATE

=DATEVALUE("12/29/04") WORKS,
BUT =DATEVALUE("TODAY()") DOESN'T

IS THERE A SOLUTION?

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?
.

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?
.

=DATEVALUE(TEXT(TODAY(),"mm/dd/yy"))

WORKS GREAT!!!

THANKS A BUNCH,

JONBOYMFLY

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?
.



.

Hi
just as a comment :-)
No need for this formula. Just use the formula
=TODAY()

shorter, simpler and also will work in non-US countries :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"JONBOYMFLY" schrieb im Newsbeitrag
...
=DATEVALUE(TEXT(TODAY(),"mm/dd/yy"))

WORKS GREAT!!!

THANKS A BUNCH,

JONBOYMFLY