I have a worksheet with 31 sheets (one for each day of a month). I would like cell D2 to auto-fill the weekday that corresponds with the sheet. For example, if D2 of Sheet 1 is Thursday, I need Sheets 2-31 to display the rest of days respectively.

I have very little experience with formulas.

Thank you so much !!