Excel formula....

[spaced]

If in column A i have a date (eg 01/02/2006), what formula would allow me to have the date in colum A, month in B and year in C and where will this formula go? Our receptionist has a list of everyones b-day's but what to seperate each, and there are hundreds.

Ta

[Dsg]

If as you say the year is in C1, the month in B1 and the day in A1 then the formula to give the date ( in D1) is

"D1=DATE(C1,B1,A1)"

You can then sort the data on any of the fields.

[Kerplunk]

If A1 = date then you can do the following

Make B1 = A1 but then custom format the cell B1 as "mmm" to give you just the month

Make C1 = A1 but then custom format the cell C1 as "yyyy" to give you just the year

You can copy these formulas using the drag method to copy them down all the cells you require.

[Aquariel]

Kerplunk is right, but if you have the date in cell A1, you can also use the following formulas:

In cell B1 put =MONTH(A1)

In cell C1 put =YEAR(A1)

Then just drag columns B and C down as far as you need.

[spaced]

ta very much!