Stories. Questions. Different perspectives.
Browse WAURE
← Explore
Technology ·

Four slash seven meant two different dates in our shared schedule

Technology category photographTechnology

My cousin said she could help on April seventh. I'd put her down for July fourth.

The shared schedule used 4/7 without a year or written month. We had filled it in from different countries and assumed the same date order. The spreadsheet displayed both entries with the same short form, which hid the disagreement until we talked about travel.

We stopped booking anything from that column and checked each ambiguous date with the person who entered it. Then we wrote the month names out in the version we circulated.

My cousin offered to take either day if it helped. That was generous, but it wouldn't tell us what everyone else had meant.

The schedule became less compact and much more useful. I miss the tidy column slightly. I would miss the extra pair of hands much more if she arrived three months before the event.

Discussion

5 community replies

Were the cells stored as recognized dates or as text? Changing how they're displayed won't necessarily recover what each person meant.

Confirm the ambiguous entries with their authors before reformatting. A consistent display can conceal consistently wrong interpretations.

Keep the original entries alongside the confirmed dates during the check. That provides a record of which ambiguity was actually resolved.

A wonderfully tidy schedule for an event happening simultaneously in April and July.

Her flexibility shouldn't become the repair for everyone else's assumptions. Confirming the whole list spreads the work fairly.

Join the discussion

0 reader replies

More in Technology

Explore more Technology stories →