Date range trouble

[ramsana]

I am doing a royalty statement where is the sale occurred on or after 01/01/14 the manager would get 15% commission and if the sale was after 01/01/14 then they would be 15% commission. I have been provided a spreadsheet that has the sales date as a range ( ex. "0110-0613"). I have tried using text to column, but excel doesn't seem to recognize the new data in the cell as a date.

Please help!

 

[shg]

Welcome to the board.

is the sale occurred on or after 01/01/14 the manager would get 15% commission and if the sale was after 01/01/14 then they would be 15% commission.

Pardon?

but excel doesn't seem to recognize the new data in the cell as a date

Neither do I. What date is it?