date conversion

New Contributor

converting a date in three cells to one cell

2 Replies
best response confirmed by mtarler (Respected Contributor)


If you have a year in A2, a month number (1 - 12) in B2 and a day number (1 - 31) in C2, the formula


will return the date.

If B2 contains a month name (for example Jan or January) instead of a month number, use


In both cases, format the cell with the formula with your preferred date format.

Thanks for your prompt reply. You have resolved my problem.