Apparently this is a very common occurrence. Immediately got on the Internet to look for an online service that allows calculate how old a person is by his date of birth.

As expected, such services exist. And not a few. Talented PHP programmers took care of "lost in time" and wrote all kinds of calculator scripts to calculate years by date of birth, or just calculate the number of years, months, days, hours, minutes and even seconds between two dates online.

I would like to write about some of them.

Calculation of how many years, months, days, hours, minutes have passed by date of birth

Many of you are probably wondering: "And how many days do I live?" . But not many bothered to count. It's a very tedious task. But with the help of this site:

can easily calculate by date of birth. You will find out how old you are, months, days, hours, minutes, seconds and even milliseconds.

The service will also give you what time your next birthday will be.

Calculate days and years between two dates - online calculator

http://planetcalc.ru/274/ - with the help of this calculator you will be able to count days and years between two dates in online mode. Just enter the required data and the service will give you the exact result.

Counting the number of days from a date to a date

http://www.calculator888.ru/skolko-dnei/ is another site where you can find out exactly how old a person is. Moreover, it can calculate online the number of years, months, days, hours, minutes, seconds elapsed from one date to another.

Using Excel, you can calculate the age of a person different ways. The table below shows the main methods you need to follow to do this with datetime functions.

To use these examples in Excel, select the data in the table, then right-click it and select Copy. Open a new sheet, right-click cell a1 and select command Paste Options _Gr_ Preserve Source Formatting.

Calculate age in Excel possible by - in different ways: either only years, or years, months and days. Calculate age for today or a specific date. There are several options.
First option.
How to calculate the number of years, months and days of age in Excel.

How to set the current date, see the article "current date in excel".
In cell C1, write the formula:
=DIFFID(A1;B1;"y")&"Year"&DIDIDAT(A1;B1;"ym")&"month"&DIDIAT(A1;B1;"md")&"days."
Let me explain the formula:
RAZDAT is the name of the function.
y - counts years
ym - counts the months
md - counts days
"year", "month", "day" written between signs & - so the years, months and days in the final date will be signed.
Happened.
How to calculate the experience with this function so that years, months and days are recorded in different columns for further addition, see the article " Calculate experience in Excel".
How to enter a cell address quickly, see the article "Addition, subtraction, multiplication, division in Excel".
If you need to calculate the age of a person on a specific date (not the current one), then in cell B2 we write this date.
Second option.
If enough count the number of full years, then we do this.
Cell A1 contains the date of birth.
Cell B2 contains the current date, if we need to calculate the age for today, or there is a date for which we need to calculate the age.
In cell D1, write the formula. We put "Equal", then we find the function "SHARE OF THE YEAR". It is located on the "Formulas" -> "Date and Time" tab. In the dialog box that appears, specify the addresses of cells with dates.
In the line "Start_date" we put the address of the cell with the date of birth.
In the line "End_date" we put the address of the cell with today's (current) date. It turned out like this.
In this window, the result of the count (54.85) is already visible. Click "OK". The resulting formula is:
=YEARFRACTION(A1,B1)
It turned out 54 years. And the numbers after the decimal point (85) are not months. They need to be removed, rounded off, but according to a special formula. It's easy.In cell E1, set the function "ROUND DOWN".
Attention!
There is also the "ROUNDDOWN" function - it does not suit us now.
So, go to the tab "Formulas" -> "Library of functions" -> "Insert function". The Function Wizard window will appear.
In the "Category" section, select "Math". In the "Select a function" window, select "RIGHT BOTTOM". Click "OK".
In the dialog box, in the "Number" line, specify the address of the cell with the number that we want to round.
In the line "Accuracy" we put the unit. It turned out like this.

Click "OK". The result is already visible in this window (54).The resulting formula is:=RIGHTDOWN(D1,1)
Everything. It turned out such a sign.
You can hide a column D and column B (for example, in the questionnaire).Right-click on the letter D (column address), select "Hide".
Third option.
How to calculate the number of full years in Excel can be calculated as well.
Cell A1 contains the date of birth.
Cell B2 contains the current date if we need to calculate the age for today.
In cell C1, write the formula:
=DIFFERENT(A1,B1,"y")
Date cells must be formatted as "Date".Where to find this function and how to install it, see the article “Excel number. Format"

The following are Chinese male names list:

Chinese male names beginning with A:

Chinese male names beginning with B:

Bai - white
Bao - treasure, jewel
Bingwen - bright and cultured
Bo-wave
Bojing - delighted with victory
Bokin - respect for the winner
Bolin - big brother's rain
Bohai - the sea of ​​the elder brother
Bay - white

Chinese male names beginning with B:

Wei - greatness
Veyzh - a great sage
Weimin - bringing greatness (to people)
Weisheng - born great
Weiyuan - preserving the depths
Wei - majesty or imposing energy
Wenkang - processing
Wenyang - purified and virtuous
Wuzhou - five continents

Chinese male names beginning with G:

Ganges - wealth
Gengis is true
Hong Kong is big or wild swan
Guang - easy
Guangli - bright
guaway - state
Gui - observant or noble
Guozhi - state order
Guoliang - a country can be kind
Gyuren - appreciation of favor

Chinese male names beginning with D:

Yes - achievement
Delun - virtuous order
Deming - dignity
Janji - handsome and distinguished
Jamming is a revolution
jen - root
Gian - healthy
Jiang - the Yangtze River
Jianguo - state system
Jianjun - army building
Jianyu - building the universe
Jing - capital (city)
Jingguo - steward of the state
Ginging - golden mirror
Jinhei - golden, marine
Dingxiang - stability and prosperity
Dong - eastern or winter
Donghei - eastern, sea
Duy - independent, integral
Day - tension

Chinese male names beginning with J:

Zhikiang - strong desire
Zhong - loyal, stable

Chinese male names beginning with Z:

Zedong - living east of the swamp
Zemin - approved by the people
Zengguang - magnifying light
Zian - peaceful
Ziksin - faith
Zihao - heroic son
Zongmeng - taking Menkius as a model
Zen - surprised
Zengzhong - upright and loyal
Zhangsheng – may government rise

Chinese male names starting with I:

Yingji - heroic
Yingpei - worthy of admiration
Yongzhang - vertical
Yonglang - bright
Yongnian - eternal years
Yongrui - always lucky

Chinese male names starting with Y:

Yi - bright

Chinese male names beginning with K:

Kang - wealth
Ki - unseen
Kiang - strong
Qianfan - a thousand sails
Kikiang - enlightenment and strength
Qingshan - a celebration of perfection
Kingsheng - birthday celebration
Kiu - autumn
Xiaauen - filial, civic duty
Xianliang - decent brightness
Xiaobo - little wrestler
Xiaodang - a little bit of dawn
Xiaojian - healthy
Xiaozi - filial thoughts
Xiaosheng - small birth
Xin - new
Xing - emerging
Xiu - grown
Xu - diligent
Xuekin - snow-white celery
Xueyu - diligent and friendly
Kuan - spring (of water)

Chinese male names starting with L:

Lei - thunder
Lee - vertical
Liang - bright
Livey - profiting and greatness
Ling - compassionate, understanding
Liu - current
Longway - the majesty of the dragon

Chinese male names beginning with M:

Mengyao - can a child be as good and wise as Menkius and Yao
Mingli - bright relevance
Ming - sensitive and wise
Mingsheng - the voice of the people

Chinese male names beginning with N:

Nianzu - thinking about ancestors

Chinese male names starting with P:

Peng - roc bird (a bird from the legend)
Pengfei - the flight of a bird
Ping - stable

Chinese male names beginning with R:

Renshu - benevolent abstinence
Rong - military
Ruthenium - scientist

Chinese male names beginning with C:

Xiu - thinking about the world
Xiangjiang - circling in the air (like a bird)

Chinese male names starting with T:

Tao - big waves
Tengfei - promotion
Tingzh - may the court be wise

Chinese male names starting with F:

Fa - outstanding
Fang - honest
Feng - sharp blade or wind
Fengj - phoenix bird
Branch - waves
Fu - rich
Fuhua - prosperous

Chinese male names beginning with X:

Hang - flood
Heng - eternal
Hee - yellow river
Hongki - red flag
Hongui - glitter
Juan - happiness
Hui - shine
Huojin - metallic
Hey - the sea

Chinese male names beginning with C:

Changming - always bright
Changpu - always simple
Chao - excess
Chaoxiang - expecting prosperity
Cheng - achieved
Chengley - big
Chongan - the world of the second brother
Chongkun - mountain of the second brother
Chonglin - second brother's unicorn
Chuanli - transfer of relevance

Chinese male names beginning with the letter W:

Shining - world
Shan - mountain
Shanyuang - the top of the mountain
Shen - cautious or deep
Shi - front horizontal bar on a wagon or cart
Shirong - academic honor
Shoushan - the mountain of longevity
Shunyuang - next to the source

Chinese male names starting with E:

Eiguo - the land of love, patriot
Enley - benefit

Chinese male names starting with Yu:

Yu is a friend
Yuanjun - Owner of the Yuan River
Yun - brave
Yunksu - cloudy void
Yusheng - jade birth
Yusheng - steady and determined

Chinese male names beginning with I:

Yang is a pattern
Yangling - Swallow Forest or Beijing Forest
Yaozu - honoring ancestors
Yaoting - respect for the courtyard
Yaochuang - worshiping the river

China - country original culture. Their religion, traditions and culture are so far from ours! This article will focus on Chinese names, the choice of which in the Middle Kingdom is still treated with special trepidation.

Exclusivity did not save the inhabitants of the Celestial Empire, they did not escape the fashion for borrowed names. But even in this, the Chinese remained true to their traditions. "Imported" names they famously adjusted to the tone of their own. Elinna - Elena, Li Qunsi - Jones. There are even names with Christian origins. For example, Yao Su My means Joseph in translation, and Ko Li Zi Si is the name George.

In China, there is a tradition of giving posthumous names. They sum up the life lived, reflect all the deeds committed by a person in this world.

How to address a resident of the Middle Kingdom?

Chinese appeals are somewhat unusual for our ears: “Director Zhang”, “Mayor Wang”. A Chinese person will never use two titles when referring to a person, such as "Mr. President". He will say "President Obama" or "Mr. Obama." When referring to a saleswoman or maid, you can use the word "Xiaojie". It looks like our "girl".

Chinese women do not take their husband's surname after marriage. "Ms. Ma" and "Mr. Wang" do not interfere in life at all. These are the laws of the country. Foreigners are most often addressed by their first names, with a polite title added if they do not know the person's profession or position. For example, "Mr. Michael". And no patronymic! It's just not here!

The Chinese are the bearers of the great ancient culture. Although China is a developed country, it occupies not the last place in the world market, but it seems that the inhabitants of a sunny state live in some special world, preserving national traditions, own way of life and philosophical attitude to the environment.