Option Two is to go-to the Formulas. In the Function and Library group, click Date and Time; in its drop-down list select EDATE. Functions Argument dialog box will appear. In the Functions ...

Excel DATEVALUE is a Date and time function, and its purpose is to converts a date in the form of text to a serial number. Learn how to use it.