Formula to calculate school grade based on birthdate


#1

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

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.


#3

That worked perfect! Thank you so much!