This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Other questions
- Re: Calculating Korean age

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Solved

Jump to Solution

0
321
1

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Apr 05, 2020 10:10 PM

Hi!

I have a formula that works awesomly to calculate international age (see below).

```
IF(
{🆔 Birthday}=BLANK(),
' (N/A)',
IF(
{🆔 Death}=BLANK(),
IF({🆔 Birthday},' ('&DATETIME_DIFF(TODAY(), {🆔 Birthday}, 'years')&')'),
IF({🆔 Birthday},' (✟ '&DATETIME_DIFF({🆔 Death}, {🆔 Birthday}, 'years')&')')
)
)
```

{ :id: Birthday} is a date field.

I’ve been trying to adapt this formula to calculate Korean age.

I would need it to do something like

`IF({🆔 Birthday},IS_BEFORE(TODAY(),DATETIME_FORMAT({🆔 Birthday}, 'MMDD'),+2 'years',+1 'Years'))`

…if that makes sense? I’ve been banging my head for too long that even the above might have an error. So in plain English: if today is before a persons birthday (but after January 1) I want it to add 2 years to their age. If it’s after their birthday I want it to add 1 year. I just can’t get it to actually work and I wouldn’t be at all suprised if it’s all down to my nesting, which I’m horribly at.

I would be endlessly gratful for any and all help with this. It would save me a huge head ache. Literally.

Solved! Go to Solution.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Not the Solution
- Report Inappropriate Content

Apr 09, 2020 10:40 AM

This is an interesting case where there can be multiple approaches.

I looked up calculating Korean age and discovered that a baby is considered 1 year old at birth and gains one year every January 1. I found this method of calculating Korean age is easier than making calculations based on the current date.

Here is my formula. It calculates the age in months from Jan 1 of the current year, divides that by 12 to convert to years, then finds the next largest integer.

```
IF({Date},
CEILING(
DATETIME_DIFF(
TODAY(),
DATETIME_PARSE("1/1/" & YEAR({Date}), "D/M/YYYY"),
'months'
)
/ 12
)
)
```

This formula does not take into account the age of a person who has died, which your original formula does. However, it looks like you understand formulas well enough to implement that part yourself. (One option would be to calculate the ages of deceases people and of live people in different fields.)

2 Replies 2

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Not the Solution
- Report Inappropriate Content

Apr 09, 2020 10:40 AM

This is an interesting case where there can be multiple approaches.

I looked up calculating Korean age and discovered that a baby is considered 1 year old at birth and gains one year every January 1. I found this method of calculating Korean age is easier than making calculations based on the current date.

Here is my formula. It calculates the age in months from Jan 1 of the current year, divides that by 12 to convert to years, then finds the next largest integer.

```
IF({Date},
CEILING(
DATETIME_DIFF(
TODAY(),
DATETIME_PARSE("1/1/" & YEAR({Date}), "D/M/YYYY"),
'months'
)
/ 12
)
)
```

This formula does not take into account the age of a person who has died, which your original formula does. However, it looks like you understand formulas well enough to implement that part yourself. (One option would be to calculate the ages of deceases people and of live people in different fields.)

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Accept as Solution
- Report Inappropriate Content

Apr 09, 2020 11:52 AM

Oh, CEILING(). Have never used that one before and though I’m sure I’ve seen it on noumerous occations while browsing the **Formula field reference page** it hadn’t stuck in memory. Now I’m curious to play around with it to first fully understand it and then find multiple uses for it.

Yes, Korean age is a bit funny as it’s uniqe in it’s approach. As Korea has a highly hierarcial society figuring out someone’s age is important though. Everyone born the same year as you are automatically the same age and a ‘friend’. Anyone older require words/speech of a different hierachy. I’m learning, but oh how I wish it was easier. Very intresting though.

Thank you so much for your help.

Accept as Solution

Reply