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.
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.
Last edited: