# Calculating Korean age

Solved
2756 2
cancel
Showing results forΒ
Did you mean:Β
7 - App Architect

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.

1 Solution

Accepted Solutions
18 - Pluto

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
18 - Pluto

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.)

7 - App Architect

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.