I'm using Numbers 3.5.2 on an iMac running Yosemite 10.10.2.
This column is a listing of dates tied to info that needs to happen on a particular date each year. Rather than re-key all the dates so the year advances to 2015, it would be great if I could change just the year for the entire column, leaving the day and month intact.
Thanks in advance for your help.
iMac (27-inch, Late 2012), OS X Yosemite (10.10.2)
If you already have a column of dates, and just want change the year in the entire column, rather than reenter the dates, then you could use a formula something like this:
The formula in B2, copied down the column:
=DATE(YEAR(A2)+1,MONTH(A2),DAY(A2))
Then select the new column, command-c to copy, and Edit > Paste Formula Results. The original column can then be deleted.
SG
If you already have a column of dates, and just want change the year in the entire column, rather than reenter the dates, then you could use a formula something like this:
The formula in B2, copied down the column:
=DATE(YEAR(A2)+1,MONTH(A2),DAY(A2))
Then select the new column, command-c to copy, and Edit > Paste Formula Results. The original column can then be deleted.
SG
SGIII has the correct, universal answer. However, this simpler quick & dirty formula will work for most cases:
=A2+365
If the current year is a leap year, you need to make this +366 for every date until March, but it's easy to check visually that the date displayed is or isn't the same, so you're unlikely to forget. If the target year is a leap year, adjust the other way.
That's a good quick and dirty approach.
To get the exact date one could also just use EDATE, simpler than my formula above:
=EDATE(A1,12)
SG
use a cell at the top of the table where you can enter the year. Let's say cell B1.
then any cells that make the specific dates can refer to that cell.
A3="1/2/"&$B$1
In Numbers, how can i change only the year in a date formatted column of data?
