Excel newbie here. I have been struggling for the past 8 hours trying to create a tracking spreadsheet that is reusable and tracks data per week for all 52 weeks in a year. I need to include 8 features (such as conditional formatting and graphs) and cannot use a template. I created an exercise data tracker, but am completely stuck on how to get all 52 weeks in without just posting each one individually. I was hoping I could use a date picker and it would change the data entered to the specific week chosen, but I don't think that's how it works. Hopefully I'm not beyond help... I've attached my spreadsheet for review.
Thank you in advance!
Bookmarks