Generating dates Using Autofill

[Guest]

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

 

[Guest]

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"

 

[Guest]

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

 

[Guest]

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

 

[David Biddulph]

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?