Forum Discussion
My Employee Attendance Record Template Calendar doesn't show date
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")
Whoa, it works! at least most of them,
I still have a problem, when I put 2021, August are empty
When I put 2022, May are empty,
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")
- ah, you are truly my savior,
and yes, checked them turned out Sunday = Minggu with abbreviation of MGG instead of MIN, hahaha,
thank you,