Once you see the Format Cells box appear on the screen you can click on Number and then select Date or Time and choose the formatting you want to appear in your spreadsheet. A1 100. There are many ways to get a date value for the first formula the date value is inserted in a cell the second formula uses the DATE function then added to the number 20.
The serial number is the calculation of a number of days from the 01011900 to a given date.
Before I show you how to use EDATE in excel let me introduce you to the syntax of EDATE function. Date function in excel is a date and time function which represents the number provided to it as arguments in a date and time code the arguments it takes are integers for day month and year separately and gives us result in a simple date the result displayed is in date format but the arguments are provided as integers method to use this formula is as follows Day Year Month Day in a sequential based. The value in each of the cells should appear as a date instead of a. Ensure the starting date is properly formatted go to Format Cells press Ctrl 1 and make sure the number is.