Retroshift
Board Regular
- Joined
- Sep 20, 2016
- Messages
- 119
- Office Version
- 2019
- Platform
- Windows
Hi,
I have this formula: =(PROPER(TEXT(TODAY();"[$-809] ddd d/mm/jj"))) which is initially a Dutch language formula (hence the "jj" and the ";"), but I wanted to return the days in English so I added the locale code 809.
The formula works perfectly on my work computer (Excel 2016 32-bit) but returns a value error on my colleague's computer with the same Excel version (2016 32 bit). Moreover, the short date settings of both computers are also the same. After an error check, it seems that the computer of the colleague returns something like a date value error. I do not have access to the colleague's computer.
Any ideas on what the issue could be here?
Thank you
I have this formula: =(PROPER(TEXT(TODAY();"[$-809] ddd d/mm/jj"))) which is initially a Dutch language formula (hence the "jj" and the ";"), but I wanted to return the days in English so I added the locale code 809.
The formula works perfectly on my work computer (Excel 2016 32-bit) but returns a value error on my colleague's computer with the same Excel version (2016 32 bit). Moreover, the short date settings of both computers are also the same. After an error check, it seems that the computer of the colleague returns something like a date value error. I do not have access to the colleague's computer.
Any ideas on what the issue could be here?
Thank you