converts days to dates

[FelyTomboy]

I want to create a calendar system in Appsheet with empty teacher schedule data for tutoring, so I tell teachers to enter data on days and times when they don't teach, so when there are new students, I can immediately look for teachers who have an empty schedule for them. . Is there a way in appsheet where we can convert days to dates? So, for example, if the teacher chooses Saturday at 5 pm, all Saturdays on the calendar will be marked. maybe there is a formula for that? please help

or if conversion from day name to date is impossible, maybe from date to day? So if the teacher inputs the date 03/13/2024, then look for what day that date is, then mark all the dates that have the same day as that date.