Forum Discussion
Date format for current month shows up differently when opened by few users
Hi All, We have a custom formula in a workbook to display month-year as "MMM-YYYY" format (Mar-2024) using formula TEXT(TODAY()-DAY(TODAY()),"MMM-YYYY"). But when this workbook is opened by few u...
That depends on regional format set on concrete machine for the OS (Windows)
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?
On Window
Settings->Time&language->Language & region->Administrative language settings->Formats tab
What is here depends on what was selected during OS installation.
SergeiBaklan - thanks for responding.
So would the OS date formats define or derive what gets displayed with this formula "=TEXT(TODAY()-DAY(TODAY()),"MMM-YYYY")" even though we are trying to set the format as "MMM-YYYY"?
We want every user to have one format as "MMM-YYYY" ('Feb-2024').
Thanks!