Q1:

=DATE(C1,B1,A1)

Q2:

="28/10/04"-"1/1/04"+1

HTH
Jason
Atlanta, GA

-----Original Message-----
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

.