Dates

[John]

How do I populate a cell with the date 01/01/xx where xx
is the year obtained from a date in another cell? i.e. I
always want the date to be Jan 1 of any year.
Thanks in advance.

 

[Frank Kabel]

Hi
try
=DATE(A1,1,1)
where A1 stores your year