Adding Year to Multiple Cells

[icreatedanexelhlepaccount]

Fairly new to excel. I am working on organizing phone records that were inserted from a PDF. There are multiple records for each date. They are listed for January 1 2014, January 2 2014, etc.

1/1
1/1
1/1
1/1
1/1
1/1
1/1
1/1
1/2
1/2
1/2

and so on...

Is there a way to add 2014 to each of these throughout the end of the year?

 

[Michael M]

What format are the 1/1, etc in ?
Is that simply text or a date ?

Maybe something like this in Column "B"

=TEXT(A2,"dd-mm")&" 2014"

 

[Jeffrey Mahoney]

if you already have a date serial number in each cell, you can just format the cells to show the year.

If you just need the year added to the text string of each cell, you can do that easily. Assuming your values start in cell A1. In cell B1 type this: =A1&"/2015". Then copy that down to the other cells.

If you want to convert the strings to actual dates, in cell B1 type: =datevalue(A1). Copy that formula down.

Hoped it helped.

Jeff

 

[icreatedanexelhlepaccount]

What format are the 1/1, etc in ?
Is that simply text or a date ?

Maybe something like this in Column "B"

=TEXT(A2,"dd-mm")&" 2014"

Yeah its a text format. That worked for me. Thanks!