Then, use the ‘date’ function to calculate a forward or backward date. You can use the date calculator for any date in between January 1 and December 31, 1999. You can use this function for future or past dates as well. Number of days between two dates You want to know how many days are … Continue reading How to Calculate the Date Using Formulas