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!
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.
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.