Change cell value Excel 2000 & 2003
 

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

Change cell value Excel 2000 & 2003
 

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



jfcby wrote:
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

Change cell value Excel 2000 & 2003
 

Assume date 1/1/2006 in A1

Load the Analysis Toolpak from ToolsAdd-ins then in A2 enter

=EDATE(A1,12)

Dragcopy down as far as you wish.


Gord Dibben MS Excel MVP

On 10 Dec 2006 12:22:30 -0800, "jfcby" wrote:

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

Change cell value Excel 2000 & 2003
 

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)


"jfcby" wrote in message
ups.com...
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

Change cell value Excel 2000 & 2003
 

Too easy<g

Gord

On Sun, 10 Dec 2006 21:22:21 -0000, "Bob Phillips" wrote:

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

Gord Dibben MS Excel MVP

Change cell value Excel 2000 & 2003
 

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



RichardSchollar wrote:
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



jfcby wrote:
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

Change cell value Excel 2000 & 2003
 

Thank you for all your help

jfcby


jfcby wrote:
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



RichardSchollar wrote:
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



jfcby wrote:
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