Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
180
Views
Topic starter
Hi all,
First of all, Happy New Year!
I have a doubt about concatenate dates , please see attach. I want to concatenate YTD with one data input.
Thanks
Posted : 02/01/2018 5:45 pm
Hi Hava,
You have to convert the date serial number in A3 to text:
="YTD "&TEXT(A3,"mmm/yy")
Note the space after YTD.
More on converting dates to text explained here: https://www.myonlinetraininghub.com/convert-dates-to-text
Mynda
Posted : 02/01/2018 6:54 pm
Topic starter
Hi Mynda!
Thanks a lot, very useful!
Regards,
Hava
Posted : 03/01/2018 3:11 pm
