Change cell value Excel 2000 & 2003

[jfcby]

Hello,

On worksheet2 B2 I have a date formated like 1/1/2006. I need to change
that value in yearly increments 1/1/2006, 1/1/2007, 1/1/2008 and so on.
How can the date be changed in yearly increments?

Thanks for your help in advance,
jfcby

 

[RichardSchollar]

You could use a formula like:

=DATE(YEAR(B2)+ROWS($B$1:$B1),MONTH(B2),DAY(B2))

in the worksheet itself.

The VBA function DateSerial works in much the same way as the worksheet
function Date, if you want a programmatical solution.

Hope this helps!

Richard

 

[Gord Dibben]

Assume date 1/1/2006 in A1

Load the Analysis Toolpak from Tools>Add-ins then in A2 enter

=EDATE(A1,12)

Drag>copy down as far as you wish.


Gord Dibben MS Excel MVP

 

[Bob Phillips]

You can just enter the first two dates, select them, and then drag and copy
to get more.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Gord Dibben]

Too easy<g>

Gord

You can just enter the first two dates, select them, and then drag and copy
to get more.

Gord Dibben MS Excel MVP

 

[jfcby]

Hello,

Is there a way to use the vba code to change the date on Sheet2 Cell 2
with a spinner button on Sheet6?

Thank you for your help,
jfcby

 

[jfcby]

Thank you for all your help

jfcby

Hello,

Is there a way to use the vba code to change the date on Sheet2 Cell 2
with a spinner button on Sheet6?

Thank you for your help,
jfcby