# Calculate age in years and months **URL:** \ **Category:** Ask for Help\ **Created:** [March 5, 2023, 4:03am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779 "2023-03-05T04:03:20Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![wink\_au](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wink_au/32/54896_2.png) [@wink\_au](https://community.glideapps.com/u/wink_au)\ **Post date:** [March 5, 2023, 4:03am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779/1 "2023-03-05T04:03:20Z")
Hi there - first time caller here 🙂 I have created a glide app from an Airtable base where there is a formula column in one of my sortable tables that calculates age in months and years from a given birthdate in another column. When I look at that data in Glide, the column is set to numbers and the age is only displayed in years. So someone 3 months old is listed as 0. I’ve looked at the various solutions in [this post](https://community.glideapps.com/t/calculate-and-display-users-age-from-date-of-birth/4049), but can’t find quite the right solution. The plugin proposed only displays years OR months, not both. There must be a simple way of doing this that I am missing…?? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2023, 5:07am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779/2 "2023-03-05T05:07:52Z")
Can you show screenshots of what you see in Airtable and what it looks like in Glide? Assuming Airtable has an underlying number with some formatting on top of it, I’m trying to understand how Glide sees it. There should be a way to get what you want in Glide, but it depends on what that underlying number is. ---
**Author:** ![wink\_au](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wink_au/32/54896_2.png) [@wink\_au](https://community.glideapps.com/u/wink_au)\ **Post date:** [March 5, 2023, 5:17am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779/3 "2023-03-05T05:17:44Z")
Appreciate your help - thanks. I’ve attached a few screen grabs of the Airtable view & details of the column settings as well as the end result in Glide. As a new user I can only upload one image, so have done a weird screen grab of the three together for you ![Screen Shot 2023-03-05 at 4.16.48 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f5c5651b9879382afd488c5ea82d512557b5562.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2023, 5:26am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779/4 "2023-03-05T05:26:50Z")
Can you also show how that column looks in the glide data editor (including headers)? Is the column configured as a number column? It might be as simple as changing the column type to text. If that is not possible, or doesn’t work, then maybe I can come up with a different solution later. It’s too late in the day for me to work on it now. Also, show the birth date column. I want to ensure that glide is seeing it as a date column. (Disclaimer: I’m not familiar with Airtable and how certain Airtable column types work with Glide, such as a formula column) ---
**Author:** ![wink\_au](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wink_au/32/54896_2.png) [@wink\_au](https://community.glideapps.com/u/wink_au)\ **Post date:** [March 5, 2023, 5:29am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779/5 "2023-03-05T05:29:31Z")
You. Are. Brilliant. Take the rest of the day off. I changed the glide column from Number to Text and that fixed the problem Thank you so much! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2023, 5:30am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779/6 "2023-03-05T05:30:27Z")
Perfect! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 6, 2023, 5:31am UTC](https://community.glideapps.com/t/calculate-age-in-years-and-months/58779/7 "2023-03-06T05:31:15Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.