All my data has been formatted as dates and it still seems to require me to select "text to columns" before it will work out the formulas, any ideas?

Thanks