Share
Explore

icon picker
Next Birthday

Get the next birthday right

get all birthdays right

make use of Date() to get the job done

⁠

Next Birthday
0
Name
person
birthday
mistaken
correct
ageToday
leapYear
1
Emmy → 2/29/1980
Emmy
2/29/1980
3/1/2025
3/1/2025
44
false
2
Naomi → 5/16/1940
Naomi
5/16/1940
5/16/2024
5/16/2024
83
true
3
Helgar → 7/25/1939
Helgar
7/25/1939
7/25/2024
7/25/2024
84
true
4
Christiaan → 8/15/1972
Christiaan
8/15/1972
8/15/2024
8/15/2024
51
true
5
Jodi → 4/25/1985
Jodi
4/25/1985
4/25/2024
4/25/2024
38
true
6
Steven → 11/30/2000
Steven
11/30/2000
11/30/2024
11/30/2024
23
true
There are no rows in this table
⁠

If(
Date(
Today().Year(),
thisRow.birthDay.Month(),
thisRow.birthDay.Day()
) >
Today(),
Date(
Today().Year(),
thisRow.birthDay.Month(),
thisRow.birthDay.Day()
),
Date(
Today().Year() + 1,
thisRow.birthDay.Month(),
thisRow.birthDay.Day()
)
)
Today().Year() - thisRow.birthday.Year() -
If(
Date(
Today().Year(),
thisRow.birthday.Month(),
thisRow.birthday.Day()
) >
Today(),
1,
0
)

Explained in this blog ⤵️

⁠
Loading
medium.com
⁠
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.