Skip to content
Share
Explore
Next Birthday
Get the next birthday right
get all birthdays right
make use of Date() to get the job done
Next Birthday
Name
person
birthday
mistaken
correct
ageToday
leapYear
Emmy → 2/29/1980
Emmy
2/29/1980
3/1/2026
3/1/2026
45
false
Naomi → 5/16/1940
Naomi
5/16/1940
5/16/2026
5/16/2026
85
false
Helgar → 7/25/1939
Helgar
7/25/1939
7/25/2026
7/25/2026
86
false
Christiaan → 8/15/1972
Christiaan
8/15/1972
8/15/2026
8/15/2026
53
false
Jodi → 4/25/1985
Jodi
4/25/1985
4/25/2026
4/25/2026
40
false
Steven → 11/30/2000
Steven
11/30/2000
11/30/2026
11/30/2026
25
false
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 ⤵️
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.