Now I understand the ask fully. Royce wants: when someone posts a whereabouts entry, note the dates, and remind the team at the beginning of that week. No existing cron jobs to worry about.
Let me map the upcoming known OOO/OOV/remote entries to their weeks. Today is Tue Jul 21. Everything before this week (Royce's DC trip, Luca's Italy) is past/current. The upcoming ones:
- Oliver — OOO Jul 24 (this week, Fri)
- Rob — OOO Aug 7 (week of Aug 3)
- Rob — OOO Aug 20–21 (week of Aug 17)
Oliver's Jul 24 is this Friday, so that week's reminder should fire basically now (Monday already passed). The two Rob entries need Monday-morning reminders for their respective weeks. Let me set those up as Monday 9am PT reminders that post to #whereabouts.