
Arithmetic operations can be performed on dates in excel. This is because dates are stored as values in excel.
Example:
Date 2020-01-01 is numbered as 43831. 2020 is a leap year and has 366 days.
366 add 43831 is 44197 which is a value for a date 2021-01-01.