Forum Discussion

Anlu42's avatar
Anlu42
Occasional Reader
Nov 14, 2025

Excel interprets dates 12 and lowers as months

Hi

If I in any cell, without any adjustment of cell formatting, excel will interpret 15/8 as 15-aug, as it should but 4/8 is interpreted as 8-apr...

Is there any way to get excel to interpret this consistently correct, that is dd/mm = dd-mmm and not "IF dd=≤12 then dd is mmm and mm=dd" which is insane?

No RepliesBe the first to reply

Resources