I have a slight problem. It would be easier to post an image but I can't because I don't have 10 reputation. Anyway I have a column with the heading "Birth Date", and dates entered in DD/MM/YYYY format such as 23/10/1987.
The birth dates were entered (not by me) as a text value I think (the format of the cells is "general"). Now I want to calculate the age of the person (in years) at the beginning of 2006. I created another cell and entered the following: 01/01/2006 (DD/MM/YYYY format). I used the DATEDIF function but then realised the dates were not in a date format. I thought Excel would be 'clever enough' to notice that it is a date. Is there an easy way to fix this problem?