![GSSJC_Backpacki GSSJC_Backpacki](https://community.airtable.com/legacyfs/online/avatars/2X/e/e924d716b90c5fa6cb3f7066f67c799119e5d8dd.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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!
![Simon_Horup_Es1 Simon_Horup_Es1](https://community.airtable.com/legacyfs/online/avatars/2X/5/56be63bf6c959524fc0492f327df36eb6b85164e.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
![GSSJC_Backpacki GSSJC_Backpacki](https://community.airtable.com/legacyfs/online/avatars/2X/e/e924d716b90c5fa6cb3f7066f67c799119e5d8dd.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2017 03:47 PM
That worked perfect! Thank you so much!
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)