Forum Discussion
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?
2 Replies
It will depend on your compute date formatting settings. Change date formats to your computer from control panel and excel will automatically treat entered data as day, month & year based on that settings.
You aware Excel does not actually “know” whether you mean dd/mm or mm/dd when you type something like 4/8. By default, Excel interprets ambiguous dates based on your system’s regional settings (Windows short date format). That’s why 15/8 works (since 15 can’t be a month, Excel has no choice but to treat it as a day), but 4/8 flips to April 8 because both 4 and 8 could be valid months.
