Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 05, 2017 12:47 PM
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!
Feb 06, 2017 02:31 PM
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.
Feb 07, 2017 03:47 PM
That worked perfect! Thank you so much!