Adding a year to a month-

[thursday140]

Good morning/afternoon,

Hope all is well! Let me get to the point. This might be quite simple. I have a list with over 1,ooo entries. The column only has months listed but I need to add the year and it has to be in this specific format.
Right now it's like this January but it needs to look like this January 2017 February 2017 and I also have months from January to present without the year listed next to the month. Any advise is helpful.

Thank you for your help,

[Olly]

Did you want the same year added to each month? Do you want the result to be text, or an actual date, with the format mmmm yyyy ?

[José Augusto]

If your data is in A1 and is numeric month use

Please Login or Register  to view this content.

or use

Please Login or Register  to view this content.

and format customize with "mmmm yyyy"

[AlKey]

Maybe with this: where month entered as text in A1 and Year in B1
Enter in C1

Please Login or Register  to view this content.

v	A	B	C
1	January	2017	January 2017
2	March	2018	March 2018

Also, if you want a real date use the same formula as above with added +0

Please Login or Register  to view this content.

This will look like:

v	A	B	C
1	January	2017	42736
2	March	2018	43160

Now you can format cells in column C as Custom, mmmm yyy

v	A	B	C
1	January	2017	January 2017
2	March	2018	March 2018