=DATE(YEAR(A1)-1,MONTH(A1),DAY(A1))


On 15 Sty, 16:22, E wrote:
I have data for 2008 which originally was just day and month (eg, 12 Jan)
which when input into Excel 2007 has become day, month and year, eg, 12 Jan
09. As this should be 2008 instead, is there a formula where I can minus one
year from the date?
Thanks.