Question: how to create a function in excel for dates?
Answer: Click inside cell A2, and we'll enter a date. ...  As you can see, there's quite a lot of Date and Time functions! ...  You're now being asked enter a full date. ...  Notice the DATE Function in the Formula bar: ...  Click the down arrow to see more options: Click the Long Date item.