Between a past date and today. It is categorized in Excel as a DateTime Function. Select the entire column you want to convert.
Now the below pop up will open and uncheck all the boxes and click the Next button.
YEARFRAC DATE G211 A21. We can define date function as the function that returns the sequential serial number which represents a date. While working or calculating dates in excel one should know the Date function. Enter your due date formula in the first empty cell under the Due Date heading.