Converting From # of Days since 1900 to Dates?

[BBA18]

I'm currently taking an REFM certification course and I'm having some trouble with dates in Excel.

Whenever I use the EDATE or EOMONTH formulas I am given a number in the 40,000s (the number of days that date is since the arbitrary 1900 start date Excel uses), and I cannot figure out how to convert that number into an actual calendar date like "1/10/2017"

What function should I use to convert this into a regular date?

 

[Eric W]

Welcome to the forum.

No function. Just format the cell as a date.

 

[BBA18]

Thanks!

How do you format a cell as a date?

 

[BBA18]

Never mind, I see how it's done.

Thanks for the help.

 

[Eric W]

You're welcome.