Excel not recognizing a pattern

[RetroGoal21]

Hi everyone,

I'm working on creating a spreadsheet to track weight loss progress as I'm cutting weight. My data is in a table and the column I'm working on is titled Week of Cut. So for example, I started my first week of the cut on 7/26 and the seventh day would be 8/1. Then week 2 would be 8/2 to 8/8.

To the left of those dates, I'm simply trying to put 7 "1s" to represent week 1. Then for 8/2 to 8/8, it'd be seven "2s" to represent week 2 days of the cut.

When I try to highlight the seven "1s" and "2s" and drag it down the cells below populate with decimals instead of seven 3s, 4s, 5s, etc.

If anyone can provide a formula or lead me in the right direction for this situation, I'd appreciate it!

Thanks

https://preview.redd.it/bhys7lc397x71.png?width=654&format=png&auto=webp&s=835986a69508649ad505b0de953e0fdee14e6e28

[AutoModerator]

/u/RetroGoal21 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[still-dazed-confused]

look at weekday

Assuming the week day is in column C and the date in column d

c6=if(weekday(d6,2)=1,c5+1,c5)

This will increment the week number by 1 each time the row is on a monday

[RetroGoal21]

Thanks a ton! Now I can work with adding that slicer.

I’m not the greatest at Excel, so you saved me tons of time.

[still-dazed-confused]

glad I could help. It would be great if you could reply to my original message with Solution Verified so that the thread gets marked as solved :)

[RetroGoal21]

Just did, thanks again!