{"id":136702,"date":"2026-07-25T22:58:09","date_gmt":"2026-07-25T22:58:09","guid":{"rendered":"https:\/\/mailinvest.blog\/index.php\/2026\/07\/25\/i-built-a-habit-tracker-in-a-weekend-using-nothing-but-an-excel-formula\/"},"modified":"2026-07-25T22:59:08","modified_gmt":"2026-07-25T22:59:08","slug":"i-built-a-habit-tracker-in-a-weekend-using-nothing-but-an-excel-formula","status":"publish","type":"post","link":"https:\/\/mailinvest.blog\/index.php\/2026\/07\/25\/i-built-a-habit-tracker-in-a-weekend-using-nothing-but-an-excel-formula\/","title":{"rendered":"I built a habit tracker in a weekend using nothing but an Excel formula"},"content":{"rendered":"

<\/a>\n<\/p>\n

\n

Fashionable life certain is hectic. It looks like there’s at all times one thing<\/em> happening. We will all construct unhealthy habits alongside the way in which. Watches, trackers, and all of the totally different productiveness apps are tremendous; however I discovered one thing that labored even higher for me: a number of formulation on an Excel spreadsheet.<\/p>\n

<\/p>\n

\n I made an exception for Excel due to its portability
\n <\/h2>\n

\n A free model of Excel is out there as a cellular app and within the cloud
\n <\/h3>\n
\n
\n
\"Creating\n <\/picture>Credit score:\u00a0David J. Buck \/ How-To Geek<\/small><\/figure>\n<\/p><\/div>\n<\/p><\/div>\n

Usually, I select open-source packages for my private tasks and experiments. However I’ve to make use of Excel at work typically (the workplace is not as eager on FOSS as I’m), so I do know my means across the program. I can wrangle spreadsheets with the very best of them.<\/p>\n

However I selected Excel for my behavior tracker for a number of different causes:<\/p>\n

    \n
  1. \n I may use a standalone app model on my cellphone.\n <\/li>\n
  2. \n I may use an older, archived model of this system and obtain the identical outcomes.\n <\/li>\n
  3. \n XLS information are suitable with LibreOffice, so I may use my spreadsheet on Home windows, Linux, and cellular. I created a brand new Microsoft account (I did not have one beforehand) with a devoted e mail handle that I by no means use. Then I used the online version of Microsoft Excel<\/a>. I doubled up on my cellphone with the app, so I might have a conveyable model of my tracker obtainable.\n <\/li>\n<\/ol>\n

    <\/p>\n

    \n I spent a while organising the visuals on my spreadsheet
    \n <\/h2>\n

    \n I will not use a tracker if I do not like taking a look at it
    \n <\/h3>\n

    I knew if I needed to make this factor work, I might need to customise it. I began by setting my font kind to Courier New<\/code> and the scale to 12. Then I used CTRL + 1<\/code> to open the cell formatting menu and instantly regulate the next:<\/p>\n