Share
Explore

icon picker
Next Birthday

Get the next birthday right
info

get all birthdays right

make use of Date() to get the job done


Next Birthday
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/2025
5/16/2025
84
false
3
Helgar → 7/25/1939
Helgar
7/25/1939
7/25/2025
7/25/2025
85
false
4
Christiaan → 8/15/1972
Christiaan
8/15/1972
8/15/2025
8/15/2025
52
false
5
Jodi → 4/25/1985
Jodi
4/25/1985
4/25/2025
4/25/2025
39
false
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 ⤵️


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.