Excel date format

Question

Hi

I have a table header containing a date ; 01/01/2020 and in the next column header I wanted the 2nd,

so thought id use = previous header + 1 , and then drag across, but I keep getting the wrong / unexpected result, 00/01/1900, I tried the same but rather than in a a table I put the result in a range cell and got the 02/01/2020, what is happening in the table and how can I avoid it?

Two ressults,

RD

Answer 1

You cannot use formulas in the column headers of a table.

Moreover, those headers are always text values, so Excel does not recognize them as dates.

Answer 2

Thanks, now i know.