DAY, MONTH, YEAR, and DATE

[Eric Starker]

You can use the DAY, MONTH, and YEAR functions to disassemble any date into its raw components, and the DATE function to put things back together again.

Read more about it. 

[#2]

I'm not sure whether this post is OK, as it looks like you are promoting your own website?

[#3]

Thanks for your concern, Jan.

I'm a community manager here at the Microsoft Tech Community.

I was asked specifically to share this piece of content by the Microsoft Excel team (who indicated this piece was worth sharing from time to time, given it contains a ton of content that is too much to be digestible in one setting). This is not my own website.

Let me know if you have any additional questions or concerns.

[#4]

OK, fair enough :)