Forum Discussion
Solved
My Employee Attendance Record Template Calendar doesn't show date
Dear all, I have issue, while tried to use Excel "Employee Attendance Record" Template, after creating, the calendar shown is empty, as follow, highlighted cell C6, with formulas as...
Udiek_Widhianto_D The relationship between these two months is that for both, the first days of the month are on a Sunday. It will produce a blank in C if there is no match and than all others on the same row will become blank.
Are you sure you entered MIN correct in C5? Is it the correct abbreviation? Silly to ask maybe. Just checking.
What do you get when you enter (anywhere):
=TEXT(DATE(2022,8,1),"ddd")
What do you expect to show to C6 cell?
- depend, I think the formula is to retrieve automatic date based on year that we input.
and based on Riny_van_Eekelen response, I solved almost all of the issue, but date in some random month still missing.
