DATE format

NikolinoDE  Thanks for your help!

I'd like to share more detailed information about my issue with date format in Excel and how I managed to resolve it.

My file contains expenditure data from 2008, with each sheet representing expenses for a specific month in the format "MMM-YY". Consequently, end-of-month balances are recorded in different cells due to varying month lengths.

I had a formula that automatically retrieved the balance from the previous month based on the current month's date, and it worked flawlessly on PC. The formula looked like this:

=@VLOOKUP(ADDRESS(55, DAY(C$1-1)+2,,,TEXT(DATE(YEAR(C$1),MONTH(C$1)-1,DAY(C$1)),"MMM-YY")))

However, on Mac, some month names were shortened to 4 letters, causing the formula to malfunction.
To address this, I discovered that the English language always shortens month names to 3 letters in the "MMM-YY" format. Therefore, I took the following steps:
Manually changed sheet names (a total of 84 sheets, covering 7 years * 12 months) from Russian to English: "янв-23" -> "Jan-23"; "фев-23" -> "Feb-23"; and so on. 😞
Updated the formula everywhere by using automatic replacement, considering the new English format:

=@VLOOKUP(ADDRESS(55, DAY(C$1-1)+2,,,TEXT(DATE(YEAR(C$1),MONTH(C$1)-1,DAY(C$1)),"[$-en-GB]MMM-YY")))