How is this date being added?

Occasional Contributor
2 Replies
best response confirmed by Priyanshu1325 (Occasional Contributor)

@Priyanshu1325 Here the sum formula includes C3 which most likely is a real date. If it contains 1 Feb 2019 that represents a numerical value of 43497. Add to these the numbers below it and you'll end up with a number 45197 which Excel then automatically translates to the date 28 Sep 2023, since C3 is also a date. A bit awkward, but that's how it is. Exclude C3 from the SUM or change the header row to texts.


Edit: Excel stores dates as sequential numbers, starting at 1 for January 1, 1900.

Thank you so much. I had no idea Excel stores dates as numbers.