Japanese version. Here are some formulas to calculate the date of the next day, the day before, etc. Steps Formulas Next day (N days later), previous day (N days before) To calculate future dates, add days to the date. (+2 means 2 days later) To calculate a date in the past, subtract days from the date. (-2 means 2 days before) Next month (after N months), previous month (before N months) Use the YEAR, MONTH, DAY, and DATE functions. Adding the number of months results in N months later, and subtracting the number of months earlier results in N months earlier. Normal calculation is performed even if the year-end and … Continue reading How to calculate dates.(Microsoft Excel)