Date question? update year.

  • Thread starter Thread starter Jman
  • Start date Start date
J

Jman

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?
 
Edit>Replace 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.
 
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.
 
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 A366>Format>Conditional 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
 
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.
 
I like how it counts the leap year when there is one.
It works. Perfectly... It will save me lots of time. Thanks.
 
Thanks for you advice.


Roger Govier said:
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 A366>Format>Conditional 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
Click to expand...
 
Back
Top