Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula to calculate school grade based on birthdate

3590 2
cancel
Showing results for 
Search instead for 
Did you mean: 
GSSJC_Backpacki
5 - Automation Enthusiast
5 - Automation Enthusiast

In an effort to move from Excel to Airtable, I need to see if it is possible for Airtable to calculate grade based on a birthdate. For example, here is my Excel formula (sorry it is a bit nightmarish):

=IF(MONTH(A1)<9,IF(MONTH(TODAY())<9,YEAR(TODAY())-YEAR(A1)-6,YEAR(TODAY())-YEAR(A1)-5),IF(MONTH(TODAY())<9,YEAR(TODAY())-YEAR(A1)-7,YEAR(TODAY())-YEAR(A1)-6))

With A1 being the location of the birthdate.

Any ideas? Is this stretching Airtable too far?

Thanks!

2 Replies 2
Simon_Horup_Es1
6 - Interface Innovator
6 - Interface Innovator

Should be possible with this formula:

IF(MONTH(Date) < 9, IF(MONTH(NOW()) < 9, (YEAR(NOW()) - YEAR(Date)) - 6,(YEAR(NOW()) - YEAR(Date)) - 5),IF(MONTH(NOW()) < 9, (YEAR(NOW()) - YEAR(Date)) - 7,(YEAR(NOW()) - YEAR(Date)) - 6))

See example Airtable.

That worked perfect! Thank you so much!