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