Auto fill a date series in Excel Filling a column or row with dates that increment by one day is very easy. 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. A simple DATE formula to return a serial number for a date This is the most obvious use of the DATE function in Excel.
To get the day name ie.
To get the day name ie. In the example shown the formula in cell C4 is. The DATEDIF formula takes two date cells and calculates the days between them. The Edate function is used to calculate the maturity date and due date that falls on the months same date as the issued date.