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

JohnSlider

New Member
Joined
Nov 23, 2015
Messages
41
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.

OjFqsAd.png
 
Last edited:

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
12,627
Just use the DATE function:

=DATE(C1,A1,B1)

and format it as a short date.
 
Upvote 0

JohnSlider

New Member
Joined
Nov 23, 2015
Messages
41
Wow.

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

Thank you, friend.
 
Upvote 0

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
12,627
I've worked with Excel for over 2 decades, and I'm still finding new things.

Happy to help.
 
Upvote 0

Forum statistics

Threads
1,190,560
Messages
5,981,693
Members
439,730
Latest member
gjvv

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top