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

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

"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

Sorryabout that I mis typed the formula which should be as you said. Problem
still remains

"xlbo" wrote:

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

It might help if you were to tell the group *what* error you encountered.

What was the formula in the cell where you had problems, what data values
was it using, and what result did you obtain?
--
David Biddulph

"Peter Iredale" <Peter wrote in message
...
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