Using formula =DATE(YEAR(K1),MONTH(K1+1),DAY(K1) starting with 01/01/2004 an
error is generated at 01/01/2005. However if I unclick Transition Formula
Evaluation and Transition Formula Entry in the Tools/OPtions/Transition tab
autofill works but formulae in other cells don't work.

Anyone got a solution to this

Am using Excel 2003