Trouble when activating edit mode

[Daniel Prag]

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. 

[#2 · Accepted solution]

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.

[#3]

Thank you! You were right. That solved my problem.