I'd be surpriosed if that formula works as is - your + 1 is in the wrong
place and you are missing a bracket.....

=DATE( YEAR(K1),MONTH(K1)+1,DAY(K1) )
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"


"Peter Iredale" wrote:

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