hi
formulas cannot return formats only values.
right click the cell in question and apply a custom format....
in the type box of the custom catagory enter....

yyyy/mm/dd

regards
FSt1

"Katerinia" wrote:

I have a worksheet with dates of mm/dd/yyyy

I need to reformat them now to be yyyy/mm/dd

Whats the formula for that?