Days since diagnosis
So I wanted to get one of those counter thingies that count how many days it's been since the Norman Conquest, or until Bush is supposed to leave office (Hah! Like that'll ever happen!)
I wanted it to display the number of days since my diagnosis. The reason for this is that my metrics charts have DSD as the x-axis. It's annoying to me to recalculate the DSD every time I skip a few days. And despite that I have several times tried, I don't see a way, using the date functions in my spreadsheet, to make it automatically calculate.
...It turned out that my spreadsheet DSD was about 20 days short. I must have skipped those days by just using the cell-above-plus-one approach in the spreadsheet when skipping actual days of testing. I didn't fix the spreadsheet data. I figure 20 days out of 880+ doesn't distort the chart much.