[SOLVED] Numbers from 3 columns to Date

[TheRobsterUK]

I have been given a spreadsheet that has Date information in 3 separate columns: A is the Day, B is the Month and C is the year, for example A=10, B=6, C=2017 would be 10th June 2016 (in British Date Format).

I have tried using =DATE(YEAR(C1), MONTH(B1), DAY(A1)) to convert the separate components into a true Date but it just returns something like 01/01/1905, which is clearly not what I'm after!

So my question is: how do I turn separate date elements into a true date in Excel?

Thanks

[modytrane]

=date(c1,b1,a1)

[TheRobsterUK]

Ah yeh obvious now! Thanks.