DashboardNovice
Member
Cell G3 = September. Cell H3 = 2014. Is it possible to join these two so that I can return the date September 1, 2014?
Converting month name and year into a date
- Thread starter DashboardNovice
- Start date
Somendra Misra
Excel Ninja
Hi,
Use below formula:
=DATE(H3,MONTH(G3&1),1)
For Text format try below:
=TEXT(DATE(H3,MONTH(G3&1),1),"mmmm d, yyyy")
Regards,
Use below formula:
=DATE(H3,MONTH(G3&1),1)
For Text format try below:
=TEXT(DATE(H3,MONTH(G3&1),1),"mmmm d, yyyy")
Regards,
Khalid NGO
Excel Ninja
Hi,
Here is another one:
=DATEVALUE(G3&H3)
Format the date as required.
Regards,
Here is another one:
=DATEVALUE(G3&H3)
Format the date as required.
Regards,