replace year in a date with year in another column

Dear All

My spreadsheet has following two columns with column A with a year and column B with date-month-year:

A B
1960 28/06/2014
1961 09/06/2014
1962 14/06/2014
1963 07/07/2014
1964 01/07/2014
1965 04/07/2014
1966 20/06/2014
1967 27/06/2014
1968 09/07/2014
1969 12/07/2014
1970 30/06/2014
1971 23/06/2014
1972 27/06/2014
1973 05/07/2014
1974 12/07/2014
1975 23/06/2014
1976 11/07/2014
1977 29/06/2014
1978 25/06/2014
1979 11/07/2014
1980 26/06/2014

What I want to do is to replace the year in column B (2014) with the year in column A. For example I want my spread sheet to be like this:

A B
1960 28/06/1960
1961 09/06/1961
1962 14/06/1962
1963 07/07/1963
1964 01/07/1964
1965 04/07/1965
1966 20/06/1966
1967 27/06/1967
1968 09/07/1968
1969 12/07/1969
1970 30/06/1970
1971 23/06/1971
1972 27/06/1972
1973 05/07/1973
1974 12/07/1974
1975 23/06/1975
1976 11/07/1976
1977 29/06/1977
1978 25/06/1978
1979 11/07/1979
1980 26/06/1980

Any way I can achieve this. Thanks a lot in advance!

Enter this in cell C1

Formula:

Please Login or Register  to view this content.

=DATE(a1,MONTH(b1),DAY(b1))

.. put this formula in column c don't delete column a and b

thanks a lot..both of this worked