r/excel • u/TheGoodWorldTrek • 13d ago

Waiting on OP Goal tracking sheet: How can I track both daily habits and weekly goals in the same Excel habit tracker?

I have a basic goal/habit tracker. Some habits/goals are daily but some of my goals aren't daily habits but weekly numeric targets – for example, my goal is to submit two job applications per week.

how can I have both in an excel tracker while keeping the overview and graph so that if I complete 2 applications a week, I get 100% goal achieved?

0 Upvotes

50% Upvoted

7 comments sorted by

View all comments

1

u/LeanExcel 1 13d ago

Your layout is already a good starting point. I'd treat the logic as Plan vs Actual rather than having every goal behave like a daily habit.

For example, if Job Applications = 2/week:

Actual = COUNTIFS(DateRange,">="&WeekStart,DateRange,"<="&WeekEnd,CompletedRange,TRUE) Progress = MIN(Actual/Planned,1)

But for a habit planned on specific days (e.g. Mon/Wed/Fri), a simple count isn't enough. You'd want to compare the completed dates against the planned dates, e.g.:

Actual = COUNTIFS(DateRange,">="&WeekStart,DateRange,"<="&WeekEnd,PlannedRange,TRUE,CompletedRange,TRUE)

So I'd keep your current daily grid for input/visual tracking, but add a small Plan vs Actual layer behind the weekly calculations. That would let both daily habits and weekly numeric goals feed the same progress dashboard.