Is it possible to do a formula like Friday+1 in a cell to generate saturday? I have a cell displaying Friday and want to drag and auto fill the days of the week for the month. B4 = FRI, and i want B5 to equal Saturday, B6 to equal sunday etc. Is there a simple way for this?