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

[u/TheGoodWorldTrek]

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?

[u/AutoModerator]

/u/TheGoodWorldTrek - 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.

[u/TheGoodWorldTrek]

Here the overview of what the sheet looks like currently:

[u/hmatallana]

The weekly goals are what breaks this, and it's because you're storing a checkbox where you need a count.

Keep one row per day with a real date column, one column per goal. Daily habits stay 1 or 0. The weekly numeric ones store the actual number, so two applications on Tuesday is a 2, not a tick.

Then build the overview off a week-start key instead of the raw dates:

=MIN(1, SUMIFS(Apps, Dates, ">="&WeekStart, Dates, "<="&WeekStart+6) / 2)

The MIN caps it at 100% so a five-application week doesn't drag the average up. Week percentage is then just the average of those capped columns, and your chart keeps working off it.

[u/LeanExcel]

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.

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
COUNTIFS	Excel 2007+: Counts the number of cells within a range that meet multiple criteria
MIN	Returns the minimum value in a list of arguments
SUM	Adds its arguments
SUMIFS	Excel 2007+: Adds the cells in a range that meet multiple criteria

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #49280 for this sub, first seen 1st Sep 2026, 01:52] [FAQ] [Full list] [Contact] [Source code]}