Forum Discussion
Solved
Trouble when activating edit mode
Hi, I am working with the Excel 2016. I downloaded a free template from the Microsoft site: https://templates.office.com/en-us/Employee-attendance-tracker-TM02780235 The problem occurs when ...
Hi Daniel,
Most probably that's since names of days of the week (SUN, MON,...) in your locale are differ from English ones.
You may slightly modify format in calendar formulas like
...TEXT(DATE(2017,ROW($A1),1),"[$-en-GB]ddd")...
or rename cells in row 5.
Or download localized version of the template if it exists, I'm not sure.
Hi Daniel,
Most probably that's since names of days of the week (SUN, MON,...) in your locale are differ from English ones.
You may slightly modify format in calendar formulas like
...TEXT(DATE(2017,ROW($A1),1),"[$-en-GB]ddd")...
or rename cells in row 5.
Or download localized version of the template if it exists, I'm not sure.
- Thank you! You were right. That solved my problem.
