Search

Dates


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.


5 views