Calculate a future date based on a given date with a powerful feature. Select the TEXT option from the next dialogue box. Date data type range from 11100 to 31129999.
The value of the year argument can include one to four digits.
The calculated value todays date is visible in the cell. The calculated value todays date is visible in the cell. Make sure delimiter is selected and click on the Next button. We can define date function as the function that returns the sequential serial number which represents a date.