Notion Templates
Notion Templates/
All Templates
All Templates/
🎂
Find Birthday/Generation
🎂

Find Birthday/Generation

Master Tag
Fun
Created
Jul 31, 2020 04:33 PM
How It Works
https://www.redgregory.com/notion/2020/7/31/fun-with-notion-find-age-and-generation-from-birthday
Usage
Abs
dateBetween
Format
Year
Less Than
Web Tags
Database
Formula
Alternatives
♋
Zodiac Formula
Cover
Age?
People
Birthday
Age
Generation?
Cusp?
Tom
Apr 5, 2008
Randall
Jun 7, 1993
Tyler
Dec 1, 1978
Poppy
Mar 15, 2008
Hannah
Jun 12, 1980
Dante
Jan 21, 1989
Susan
Oct 1, 1956
Lorrie
Aug 19, 2014
Formulas
Age? - format(dateBetween(now(), prop("Birthday (Date)"), "years")) + " Years Old"
Generation? - if(year(prop("Birthday")) >= 2013, "Gen Alpha", if(year(prop("Birthday")) >= 1995, "Gen Z", if(year(prop("Birthday")) >= 1980, "Millennial", if(year(prop("Birthday")) >= 1975, "Xennial", if(year(prop("Birthday")) >= 1965, "Gen X", if(year(prop("Birthday")) >= 1946, "Boomer", if(year(prop("Birthday")) >= 1925, "Silent Generation", if(year(prop("Birthday")) >= 1910, "Greatest Generation", if(year(prop("Birthday")) >= 1901, "Interbellum Generation", if(year(prop("Birthday")) >= 1890, "Lost Generation", ""))))))))))
Cusp? - if(abs(year(prop("Birthday")) - 2013) < 2, "Gen Z/Gen Alpha", if(abs(year(prop("Birthday")) - 1995) < 2, "Millennial/Gen Z", if(abs(year(prop("Birthday")) - 1980) < 2, "Xennial/Millennial", if(abs(year(prop("Birthday")) - 1975) < 2, "Gen X/Xennial", if(abs(year(prop("Birthday")) - 1965) < 2, "Boomer/Gen X", if(abs(year(prop("Birthday")) - 1946) < 2, "Silent Generation/Boomer", if(abs(year(prop("Birthday")) - 1925) < 2, "Greatest Generation/Silent Generation", if(abs(year(prop("Birthday")) - 1910) < 2, "Interbellum Generation/Greatest Generation", if(abs(year(prop("Birthday")) - 1901) < 2, "Lost Generation/Interbellum Generation", "")))))))))