i am currently using =TODAY()+8-WEEKDAY(TODAY(),12) to autofill the week ending Tuesday on our time sheets, now i want to autofill the work days up to that date, so Wed, Thurs, Fri, Mon, and Tue. the Tuesday will be the same formal my question is how to solve for the rest of the days, and be able to print it out any day up to the week ending Date (Tues).