Create Date from 3 cells

[slam]

Hi everyone!

Example of my data, all formatted as General:

• In B2, I have the year: 2020
• In B3, I have the month: January
• In B4, I have the day of the month: 12

In B1, I wanted to create a date from these 3 cells in the format MM/DD/YYY, so this should appear as 1/12/2020 (or 01/12/2020 is okay as well) - sorry the for crazy American date format

The reason I can't just create the first date, then drag across, is that there are many gaps in the dates, and my data goes up to column AWU.

Is there a formula that could do this?

Excel 365

Thanks!

 

[Joe4]

This works for me (I am using an American version).

Formula:

=DATEVALUE(CONCATENATE(B3," ",B4,", ",B2))

and then format the cell the formula is in with a date format of MM/DD/YYYY

 

[slam]

Perfect, thank you so much, Joe!

 

[Joe4]

You are welcome.
Glad I was able to help!