A unique integer representing a specific date, calculated as the number of days elapsed since January 1, 1900.
Pruébalo con IAExcel stores dates as sequential numbers to allow for mathematical calculations like addition and subtraction. The number 1 represents January 1, 1900, and each subsequent day increments this value by one.
The date January 1, 2024, is stored as the serial number 45292.
This happens when the cell is formatted as 'General' or 'Number' instead of a 'Date' format.