Notice that the dates in range G$4$:G$50$ are not formatted to display the year. Change the format of the date range $($G$4$:G$50)$ to any date format that displays a $2$ digit year, but no information about the time of the day.