How do I change date based on year
 

Hi,

I have a list of dates as below:
01/01/07
01/02/07
01/03/07
01/04/07 etc for a whole year

However, I'd like the list to change to 08, 09, 10 etc. when the year
changes. I tried doing this by entering the TODAY formula into a cell and
then using the YEAR formula to extract the correct year. I then entered the
formula =01/01/'cell with year formula in' into the first cell of my dates
range but this did not work.

I'm sure there's a simple way around this. I'd be greatful if anyone could
point me in the right direction.

Thanx

How do I change date based on year
 

one way:

For you first date:

=DATE(YEAR(Today(),1,1) in say A1

in A2 = A1+1

Copy A2 down for the year

"Hannah" wrote:

Hi,

I have a list of dates as below:
01/01/07
01/02/07
01/03/07
01/04/07 etc for a whole year

However, I'd like the list to change to 08, 09, 10 etc. when the year
changes. I tried doing this by entering the TODAY formula into a cell and
then using the YEAR formula to extract the correct year. I then entered the
formula =01/01/'cell with year formula in' into the first cell of my dates
range but this did not work.

I'm sure there's a simple way around this. I'd be greatful if anyone could
point me in the right direction.

Thanx

How do I change date based on year
 

... missing bracket ...

=DATE(YEAR(TODAY()),1,1)

"Toppers" wrote:

one way:

For you first date:

=DATE(YEAR(Today(),1,1) in say A1

in A2 = A1+1

Copy A2 down for the year

"Hannah" wrote:

Hi,

I have a list of dates as below:
01/01/07
01/02/07
01/03/07
01/04/07 etc for a whole year

However, I'd like the list to change to 08, 09, 10 etc. when the year
changes. I tried doing this by entering the TODAY formula into a cell and
then using the YEAR formula to extract the correct year. I then entered the
formula =01/01/'cell with year formula in' into the first cell of my dates
range but this did not work.

I'm sure there's a simple way around this. I'd be greatful if anyone could
point me in the right direction.

Thanx

How do I change date based on year
 

=DATE(YEAR(TODAY()),MONTH(ROW(A1)),1)

and copy down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hannah" wrote in message
...
Hi,

I have a list of dates as below:
01/01/07
01/02/07
01/03/07
01/04/07 etc for a whole year

However, I'd like the list to change to 08, 09, 10 etc. when the year
changes. I tried doing this by entering the TODAY formula into a cell and
then using the YEAR formula to extract the correct year. I then entered
the
formula =01/01/'cell with year formula in' into the first cell of my dates
range but this did not work.

I'm sure there's a simple way around this. I'd be greatful if anyone could
point me in the right direction.

Thanx

How do I change date based on year
 

Thanx, i'll try that.

"Toppers" wrote:

.. missing bracket ...

=DATE(YEAR(TODAY()),1,1)

"Toppers" wrote:

one way:

For you first date:

=DATE(YEAR(Today(),1,1) in say A1

in A2 = A1+1

Copy A2 down for the year

"Hannah" wrote:

Hi,

I have a list of dates as below:
01/01/07
01/02/07
01/03/07
01/04/07 etc for a whole year

However, I'd like the list to change to 08, 09, 10 etc. when the year
changes. I tried doing this by entering the TODAY formula into a cell and
then using the YEAR formula to extract the correct year. I then entered the
formula =01/01/'cell with year formula in' into the first cell of my dates
range but this did not work.

I'm sure there's a simple way around this. I'd be greatful if anyone could
point me in the right direction.

Thanx