TLB Tip 006 - The @Date Menu
Oct 18, 2024
As educators, incorporating dates into your digital trackers are necessary for many instances. I'm going to show you a super useful trick for this!
Take a blank cell in your Sheet and type "@" followed by "date":
Typing "@date" into a cell brings up the date picker object, with today's date highlighted.
Press Enter to select today's date or use the picker to select a different date.
Other @ Date menu choices
There are a several other date menu choices available.
Try typing the following:
- @today → inserts today's date
- @tomorrow → inserts tomorrow's date
- @yesterday → inserts yesterday's date
- @mon or @monday → Brings up list of recent Monday's (works for other days of the week e.g. @tue or @tuesday)
- @next → week on Monday or 2 weeks on Monday
- @next tue or @next tuesday → week on Tuesday (works for other days of the week too)
- @last → week last Monday, or one before that
- @last wed or @last wednesday → week last Wednesday, or one before that (works for other days of the week too)
Did I miss any?
What else does the "@" menu offer
The "@" menu is more than just dates of course.
You can also add people, files, calendar events, and emojis! Just type "@" into a cell and a menu will appear with all of these options!
I hope you found this week's tip super insightful!
