Date help please

[peter.thompson]

I have a worksheet with day in A1, month in A2 and Year in A3. The cells are formatted =Day(xx),=Month(xx),=Year(xx) repectively, where xx represent the cells containing the source data. I want to combine these into another cell that shows the precise full date - have been playing with the '&" function to no avail.

Any help much appreciated

Cheers

Peter

[Vito]

Does this work?

=DATE(A3,A2,A1)

[peter.thompson]

Works like a charm!

Thanks Vito

Cheers

Peter