Hi
Q1
In D1 enter
=DATE(C1,B1,A1)
and format as date

Q2:
=DAY(A1)-DAY(DATE(2003,12,31))

"Anthony Slater" wrote:

Q1
I have inherited a spreadsheet that has the date split over 3 columns: -
a1 = day
b1 = month
c1 = year

How can I put these in one column to read dd/mm/yyy

Q2

How can I work out the day number of a particular date?

Ie 28/10/2004 = 302


I also need to take into consideration the leap years accordingly

TIA