Post your formula. Also, what is the format of the source cell? mm/dd/yy,
yyyy-mm-dd, etc.

Biff

"Vijay Kotian" wrote in message
...
How to get the actual date format while concatenate formala is applied. I
am
getting value of date instead of DATE. Pl. help me