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