Date question? update year.
 

I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to 2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become inacurate.
Is there an easier way?

Date question? update year.
 

EditReplace will work but the only problem would be *if* you have dates in
February related to leap years.

For example, if you have:

2/28/2008
2/29/2008

Since 2009 is not a leap year then 2/29/2009 is an obvious error and it will
be converted to a TEXT entry.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to 2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become inacurate.
Is there an easier way?

Date question? update year.
 

Oh i see, it make sens..
Is there is no way i can update them through a macro
If there is no other way, i'll just delete them and scroll down the dates
for the current year.

"T. Valko" wrote:

EditReplace will work but the only problem would be *if* you have dates in
February related to leap years.

For example, if you have:

2/28/2008
2/29/2008

Since 2009 is not a leap year then 2/29/2009 is an obvious error and it will
be converted to a TEXT entry.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to 2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become inacurate.
Is there an easier way?

Date question? update year.
 

Hi

in cell A1 enter 01 Jan 2008 (in the format you use for your Region)
in cell A2 enter
=A1+1
Copy down to A366

Select cell A366FormatConditional Formatting Formula Is
=YEAR(A366)<YEAR(A365)Format Select White font (or font same colour as
background.

To change the dates each year, just enter a new value in cell A1

--
Regards
Roger Govier

"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to 2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become inacurate.
Is there an easier way?

Date question? update year.
 

How about a formula that will automatically change when the year changes?

Enter this formula in A1:

=DATE(YEAR(NOW()),1,1)

Enter this formula in A2 and copy down to A365:

=A1+1

Enter this formula in A366:

=IF(MONTH(A365+1)=1,"",A365+1)

Format as DATE to suit.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
Oh i see, it make sens..
Is there is no way i can update them through a macro
If there is no other way, i'll just delete them and scroll down the
dates
for the current year.

"T. Valko" wrote:

EditReplace will work but the only problem would be *if* you have dates
in
February related to leap years.

For example, if you have:

2/28/2008
2/29/2008

Since 2009 is not a leap year then 2/29/2009 is an obvious error and it
will
be converted to a TEXT entry.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to
2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become
inacurate.
Is there an easier way?

Date question? update year.
 

I like how it counts the leap year when there is one.
It works. Perfectly... It will save me lots of time. Thanks.


"T. Valko" wrote:

How about a formula that will automatically change when the year changes?

Enter this formula in A1:

=DATE(YEAR(NOW()),1,1)

Enter this formula in A2 and copy down to A365:

=A1+1

Enter this formula in A366:

=IF(MONTH(A365+1)=1,"",A365+1)

Format as DATE to suit.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
Oh i see, it make sens..
Is there is no way i can update them through a macro
If there is no other way, i'll just delete them and scroll down the
dates
for the current year.

"T. Valko" wrote:

EditReplace will work but the only problem would be *if* you have dates
in
February related to leap years.

For example, if you have:

2/28/2008
2/29/2008

Since 2009 is not a leap year then 2/29/2009 is an obvious error and it
will
be converted to a TEXT entry.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to
2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become
inacurate.
Is there an easier way?

Date question? update year.
 

Thanks for you advice.


"Roger Govier" wrote:

Hi

in cell A1 enter 01 Jan 2008 (in the format you use for your Region)
in cell A2 enter
=A1+1
Copy down to A366

Select cell A366FormatConditional Formatting Formula Is
=YEAR(A366)<YEAR(A365)Format Select White font (or font same colour as
background.

To change the dates each year, just enter a new value in cell A1

--
Regards
Roger Govier

"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to 2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become inacurate.
Is there an easier way?

Date question? update year.
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...

I like how it counts the leap year when there is one.
It works. Perfectly... It will save me lots of time. Thanks.


"T. Valko" wrote:

How about a formula that will automatically change when the year changes?

Enter this formula in A1:

=DATE(YEAR(NOW()),1,1)

Enter this formula in A2 and copy down to A365:

=A1+1

Enter this formula in A366:

=IF(MONTH(A365+1)=1,"",A365+1)

Format as DATE to suit.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
Oh i see, it make sens..
Is there is no way i can update them through a macro
If there is no other way, i'll just delete them and scroll down the
dates
for the current year.

"T. Valko" wrote:

EditReplace will work but the only problem would be *if* you have
dates
in
February related to leap years.

For example, if you have:

2/28/2008
2/29/2008

Since 2009 is not a leap year then 2/29/2009 is an obvious error and
it
will
be converted to a TEXT entry.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to
2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become
inacurate.
Is there an easier way?