Best practice: Eerily accurate anniversaries

Google Sheets
Google Sheets

Note: Marieke and I got divorced in 2020. This post might not reflect the current situation.

[vc_row type=”full_width_background” full_screen_row_position=”middle” column_margin=”default” scene_position=”center” text_color=”dark” text_align=”left” top_padding=”0″ bottom_padding=”3%” overlay_strength=”0.3″ shape_divider_position=”bottom” bg_image_animation=”none” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][vc_row_inner column_margin=”20px” bottom_padding=”2%” text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”1/4″ tablet_width_inherit=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][vc_custom_heading text=”INSIGHT / BELIEF” font_container=”tag:h5|font_size:14|text_align:left|color:%23b2b2b2″ google_fonts=”font_family:Hind%3A300%2Cregular%2C500%2C600%2C700|font_style:500%20bold%20regular%3A500%3Anormal”][vc_column_text]Forgetting dates and anniversaries s*cks.[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”1/4″ tablet_width_inherit=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][vc_custom_heading text=”CHALLENGE” font_container=”tag:h5|font_size:14|text_align:left|color:%23b2b2b2″ google_fonts=”font_family:Hind%3A300%2Cregular%2C500%2C600%2C700|font_style:500%20bold%20regular%3A500%3Anormal”][vc_column_text]Find an easy way to remember anniversaries correctly.[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”1/4″ tablet_width_inherit=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][vc_custom_heading text=”SOLUTION” font_container=”tag:h5|font_size:14|text_align:left|color:%23b2b2b2″ google_fonts=”font_family:Hind%3A300%2Cregular%2C500%2C600%2C700|font_style:500%20bold%20regular%3A500%3Anormal”][vc_column_text]Google sheet that automatically calculates anniversary dates.[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” width=”1/4″ tablet_width_inherit=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][vc_custom_heading text=”BENEFITS” font_container=”tag:h5|font_size:14|text_align:left|color:%23b2b2b2″ google_fonts=”font_family:Hind%3A300%2Cregular%2C500%2C600%2C700|font_style:500%20bold%20regular%3A500%3Anormal”][fancy-ul icon_type=”none” alignment=”left” spacing=”default”]
  • Happy wife 🙂
[/fancy-ul][/vc_column_inner][/vc_row_inner][divider line_type=”Full Width Line” line_thickness=”1″ divider_color=”default” animate=”yes” custom_height=”40″][/vc_column][/vc_row][vc_row type=”full_width_content” full_screen_row_position=”middle” column_margin=”default” scene_position=”center” text_color=”dark” text_align=”left” top_padding=”0″ overlay_strength=”0.3″ shape_divider_position=”bottom” bg_image_animation=”none” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1/12″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][/vc_column][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”5/6″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][image_with_animation image_url=”275425″ alignment=”” animation=”Fade In” hover_animation=”none” border_radius=”none” box_shadow=”none” image_loading=”default” max_width=”100%” max_width_mobile=”default”][/vc_column][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1/12″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][/vc_column][/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″ shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self” column_shadow=”none” column_border_radius=”none” width=”1/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” overlay_strength=”0.3″ column_border_width=”none” column_border_style=”solid” bg_image_animation=”none”][vc_column_text]The setting.

It is a double-date. Another couple comes to visit you and your partner. And somewhere along the evening, the inevitable questions arises: “so, how long have you guys been together?”. For most guys, it is one of the most dreaded questions, because we tend to forget. It is the adult equivalent of being singled out by your high school teacher with a question you don’t know the answer too. Your partner eyeing you while you try to remember and hastily try to put together the dates in your head … we have been together since april and that was the year before I started working in my new job and that has been … ah, no wait, it was when we first went to Italy … and the moment you answer and your partner rolls her eyes and gives the correct answer (but hey, you were close, only a 18-month difference), you know it’s an uphill battle to regain your best-partner-in-the-world-status.

I was that guy.

Enter Google Docs and my radical nerdy solution to never forget anniversaries.

I created a new Google Docs Spreadsheet which calculates the exact number of days since key anniversaries. Today, we have been married 1360 days. We met each other 2699 days ago and have been in a relationship for 2656 days.

It works pretty simple:

  • I have one field with today’s date – formula=TODAY()
  • I have a field for every single date I want to calculate the number of days of (e.g. when we were married, 18th of May 2013)
  • I have another field that subtracts the second date (our marriage) from today’s date and uses standard time formatting days (you can select this from the menu) to calculate the number of days.

As Google Sheets is pretty flexible, there are plenty of tools that can help you with sending you an email with the updated number of days every day or even turn it into a chatbot.

Here you are. An eerily accurate way to calculate anniversaries. So next time the question arises “so, how long have you guys been together?”, you’re definitely #winning.[/vc_column_text][/vc_column][/vc_row]

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like
Tim de Kegel
Yes! I want to learn more

Better presentations: Janssen Belgium tweeting their quotes

[vc_row type=”full_width_background” full_screen_row_position=”middle” column_margin=”default” scene_position=”center” text_color=”dark” text_align=”left” top_padding=”0″ bottom_padding=”5%” overlay_strength=”0.3″ shape_divider_position=”bottom” bg_image_animation=”none” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self”…
Kimpton Social Hour
Yes! I want to learn more

Kimpton ‘Social Hour’: brand storytelling with Champagne

[vc_row type=”in_container” full_screen_row_position=”middle” equal_height=”yes” content_placement=”bottom” column_margin=”default” bg_image=”273920″ bg_position=”center center” bg_repeat=”no-repeat” scene_position=”center” text_color=”light” text_align=”left” top_padding=”6%” enable_gradient=”true” color_overlay_2=”rgba(10,10,10,0.87)” gradient_direction=”left_t_to_right_b” overlay_strength=”0.5″…
Van Moof Bike Box
Yes! I want to learn more

Best practice: Van Moof is shipping bikes as TV’s

[vc_row type=”full_width_background” full_screen_row_position=”middle” column_margin=”default” scene_position=”center” text_color=”dark” text_align=”left” top_padding=”0″ bottom_padding=”3%” overlay_strength=”0.3″ shape_divider_position=”bottom” bg_image_animation=”none” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self”…
Apple System Status
Yes! I want to learn more

Best practice: Apple being transparent about their system status

[vc_row type=”full_width_background” full_screen_row_position=”middle” column_margin=”default” scene_position=”center” text_color=”dark” text_align=”left” top_padding=”0″ bottom_padding=”3%” overlay_strength=”0.3″ shape_divider_position=”bottom” bg_image_animation=”none” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_link_target=”_self”…