Forum Discussion
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 I activate edit mode. Then all of the dates disappear. See screenshots.
I really appreciate all the help I could get.
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.
2 Replies
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.
