Date format for current month shows up differently when opened by few users

Question

Hi All,&nbsp;We have a custom formula in a workbook to display month-year as "MMM-YYYY" format (Mar-2024) using formula&nbsp;TEXT(TODAY()-DAY(TODAY()),"MMM-YYYY"). But when this workbook is opened by few users, formula cell is display text like (3-2024) monthnumber-year format. What might be causing this and how can we fix this?&nbsp;Regards,Naresh&nbsp;

sergeibaklan · Answer

NareshBabu1511&nbsp;
That depends on regional format set on concrete machine for the OS (Windows)

nareshbabu1511 · Answer

Thanks for the response Sergei. Users are all located in same region, but it is happening only for few of them. Is there a place where we can check this?

sergeibaklan · Answer

NareshBabu1511&nbsp;
On Window
Settings-&gt;Time&amp;language-&gt;Language &amp; region-&gt;Administrative language settings-&gt;Formats tab

What is here depends on what was selected during OS installation.

nareshbabu1511 · Answer

SergeiBaklan&nbsp;- thanks for responding.&nbsp;So would the OS date formats define or derive what gets displayed with this formula&nbsp; "=TEXT(TODAY()-DAY(TODAY()),"MMM-YYYY")" even though we are trying to set the format as "MMM-YYYY"?&nbsp;We want every user to have one format as "MMM-YYYY" ('Feb-2024').&nbsp;Thanks!&nbsp;

Forum Discussion

Date format for current month shows up differently when opened by few users

Share

Resources