Formulating a date in one cell from month, day, and year stated separately in others

[JohnSlider]

Greetings all!

I have a spreadsheet where people identify milestones and the Month of the Year, Day of the Month, and Year that they take place in three separate cells. I do this because on another sheet I have to identify the number of milestones occurring in each month of each year.

However! I'd also like to reference the full date somewhere else in the book. Is there a way to add a column and enter a formula to make Excel present the full (short) date? So '1/3/2020' for the below example. It's important that Excel recognizes it as a date and not just general text saying 1/3/2020.

 

[Eric W]

Just use the DATE function:

=DATE(C1,A1,B1)

and format it as a short date.

 

[JohnSlider]

Wow.

Working with Excel for over a year now and the simplest things are still blowing my mind.

Thank you, friend.

 

[Eric W]

I've worked with Excel for over 2 decades, and I'm still finding new things.

Happy to help.