Today, I have three date formulas for you that come from Red Gregory's thread. If you are not familiar with her, she is like the goddess of Notion formulas.

‍

1- Format the start & end time of an event:

if(not empty(prop("Date")), formatDate(prop("Date"), "LT-") + formatDate(end(prop("Date")), "LT"), "")

‍

‍

2- Get the duration of an event:

if(not empty(prop("Date")), format(dateBetween(end(prop("Date")), start(prop("Date")), "hours")) + " hr " + format(dateBetween(end(prop("Date")), start(prop("Date")), "minutes") % 60) + " m", "")

‍

‍

3- Get the age from a birth date:

if(not empty(prop("Birthday")), format(dateBetween(now(), prop("Birthday"), "years")) + " years old", "")

‍