Hi there,

I need some help with a formula converting a non-standard date format to a standard date format.

I have a massive spreadsheet where the dates are in the following format:

"50,725" is 25 July 2005 - I can remove all the commas but I still need some help getting the entries converted.

PLEASE HELP!

Thnks