Im trying to create a calendar that is for a year long, and can be changed with just entering the start date in a specific cell. I need the calendar to show the Month, Date, and Day in seperate rows. Im having trouble changing the Day and as of now have to enter it manually. But I would like it to change with the rest of the calendar. So what I have done is assign numerical values for the days 1234567 for SMTWTFS. I created a row that changes this value using the =Weekday function. all I need is a function to add the letter character to the corresponding number.
