Site icon ExcelNotes

What will be the Dates after a Period of Time

The dates store as serial numbers in Excel. If you have a list of dates and wonder what would be the dates after a period of time, you can use the DATE function, which will merge year, month and day together.

1. Please use the formula below if you want to know the dates after some days (e.g., 300 days), please change "300" to the days you want.

=DATE(YEAR(A2), MONTH(A2), DAY(A2)+300)

2. Please use the formula below if you want to know the dates after some months (e.g., 8 months), please change "8" to the months you want.

=DATE(YEAR(A2), MONTH(A2)+8, DAY(A2))

3. Please use the formula below if you want to know the dates after some years (e.g., 5 years), please change "5" to the years you want.

= DATE(YEAR(A2)+5, MONTH(A2), DAY(A2))

4. Please use the formula below if you want to know the dates after years, months and days (e.g., 5 years 8 months and 300 days), please change the numbers in the formula to the ones you want.

=DATE(YEAR(A2)+5, MONTH(A2)+8, DAY(A2)+300)

When the days and months are greater than the maximum number (e.g., 12 months a year), the number will automatically transfer to the years, the months and the days. For example, 13 months equal to 1 year and 1 month.

Exit mobile version