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).
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Automatically fill in dates for time sheets
- Thread starter water_boy
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,653
- Office Version
- 365
- Platform
- Windows
Maybe
| +Fluff 1.xlsm | |||
|---|---|---|---|
| A | |||
| 1 | |||
| 2 | 08/02/2022 | ||
| 3 | 07/02/2022 | ||
| 4 | 06/02/2022 | ||
| 5 | 05/02/2022 | ||
| 6 | 04/02/2022 | ||
| 7 | 03/02/2022 | ||
| 8 | 02/02/2022 | ||
| 9 | |||
Main | |||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A2 | A2 | =WORKDAY.INTL(TODAY(),1,"1011111") |
| A3:A8 | A3 | =A2-1 |
Upvote
0
Similar threads
- Solved
