People

Age

dateBetween(now(), prop("Birthday"), "years")

Next Birthday

if(formatDate(dateAdd(prop("Birthday"), dateBetween(now(), prop("Birthday"), "years"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("Birthday"), dateBetween(now(), prop("Birthday"), "years"), "years"), dateAdd(prop("Birthday"), dateBetween(now(), prop("Birthday"), "years") + 1, "years"))

Birthday Today/Tomorrow

if(formatDate(prop("Next Birthday"), "L") == formatDate(now(), "L"), "🎂 Today", if(formatDate(prop("Next Birthday"), "L") == formatDate(dateAdd(now(), 1, "days"), "L"), "🎁 Tomorrow", ""))

Anniversaries

dateBetween(now(), prop("Anniversary"), "years")

Next Anniversary

if(formatDate(dateAdd(prop("Anniversary"), prop("Anniversaries"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("Anniversary"), prop("Anniversaries"), "years"), dateAdd(prop("Anniversary"), prop("Anniversaries") + 1, "years"))

Anniversary Today/Tomorrow

if(formatDate(prop("Next Anniversary"), "L") == formatDate(now(), "L"), "💍 Today", if(formatDate(prop("Next Anniversary"), "L") == formatDate(dateAdd(now(), 1, "days"), "L"), "💞 Tomorrow", ""))

Next Birthday (Using Age)

if(formatDate(dateAdd(prop("Birthday"), prop("Age"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("Birthday"), prop("Age"), "years"), dateAdd(prop("Birthday"), prop("Age") + 1, "years"))

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>