Tricky question in Excel If you have a date cell, and want to make other cell contains a fixed day & month, but changeable year matches the 1st cell?

Try this formula:   ="6/4/"&YEAR(A1) 

Note: A1 should be the cell that contains your information reference.  So if you're typing at C1, your formula shoud be ="6/4/"&YEAR(C1).

=DATE(YEAR(A1),6,4)

Great answers.

Try this formula:    =DATE(YEAR(A1);4;6)

Any other ideas? :)

="6/4/"&YEAR(A1)

Type in B1

="6/4/"&YEAR(A1)

OR

=TEXT(("6/4/"&YEAR(A1)),"dd/mm/yy")

after you fix the date in the first cell, click on the next cell and put the equation (the first cell +365 or366 if the next year is leap year)

Dear Sir,

Your Date column selecting after right button pressing your mouse. when coming some details select the format Cell After selecting the Text. Which one you want here come to that

I Agreed with most answers

="6/4/"&YEAR(A1)

simple as it

="6/4/ "&YEAR(A1)

or using Concatenate

 OR

also Making a Format of the Cell Use CTRL+1 and format date accordindly