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
|