← Back to context

Comment by davchana

3 years ago

I am doing an excel sheet, 52 boxes per row, one row per year. Inspired by waitbutwhy article.

Do you find some years need 53 boxes?

If you're born April 1, 52 weeks after your birth would be March 31, and after 52 more weeks it would be March 30 (before considering leap years).

I guess it can stay 52 boxes, and the last box has a day extra (or two, on leap years).

  • Oh no, I don't go in that details, simply, every month, the weeks start on 1st, 8th, 15th, 22nd.

    Only Jan, Jun, July, Dec gets another week, 5th one, on 27th.

    So all months have 4 columns, labeled 1,8,15,22. Jan, Jun, Jul, Dec have 5 columns.

    Whole sheet is a fillable grid of 52 columns and 90 rows.

    A pre column list the year like 2002, 2003, 2004 etc. Next pre column list my age like 0,1,2,3 till 90. Then above explained grid. Then again, first two pre columns copied.

    Each cell has light grey border. Border darkens to black between months columns. Border also darkens at every decade row.

    If an event (like travel) happens on certain date (like 13th), it simply fills the whole week.

    I assume that in overall big picture of life, a rounding off of week will not matter much.