興趣嗜好今日: 0|主題: 123788

收藏本版

發帖

返回列表

跳至頁

查看: 823 | 回覆: 5

[電腦] excel 一問? [複製鏈接]

學勤咪咪

別墅

積分: 847

1^#

發表於 06-5-10 11:45 |只看該作者

excel 一問?

Dear,

我做緊staff profile,請問excel點樣set formual可以計到同事的年齡，只入出生日期，它會同我計算嗎？

呢樹有冇高手可以幫到我呢？謝謝！

我中文名學勤，英文名係Howard，香港山頂嘉諾撒醫院面世。 27/7/2005-weight:12.9kg, height:86cm 17/9/2005 - weight:13.5kg, height:89cm 1/4/2006 - weight:14.3kg, height:93cm

私人傳訊

simon00

複式洋房

積分: 220

2^#

發表於 06-5-10 12:22 |只看該作者

Re: excel 一問?

It depends on what information do you have and how accurate do you want?

For example:

For cell A1, type =TODAY()
for cell A2, type =12/25/1970
for cell A3, type = A1-A2

The result gives 5/16/35, that means 35 years, 5 months and 16 days old. BUT remember to format the cell A3 in the form of DATE (12/25/98 instead of 12/25/1998). Otherwise, it would shows a wrong data.

May be someone can have a better way.

私人傳訊

kuno

複式洋房

積分: 351

3^#

發表於 06-5-10 12:42 |只看該作者

Re: excel 一問?

=DATEDIF(A1,TODAY(),"y")

where A1 = DOB

我的羊聽我的聲音、我也認識他們、他們也跟著我。
我又賜給他們永生．他們永不滅亡、誰也不能從我手裏把他們奪去。
我父把羊賜給我、他比萬有都大．誰也不能從我父手裏把他們奪去。我與父原為一。 (約 10:27-29)
天約的世界-http://www.mymicah.com/
方舟人家-http://hk.myblog.yahoo.com/BB-MAMA/

私人傳訊

學勤咪咪

別墅

積分: 847

4^#

發表於 06-5-10 14:37 |只看該作者

Re: excel 一問?

kuno,

I tried to use your formula, but I'm not sucessful.

Born Date is 05/10/1960 in cell M1
=DATEDIF(M1,TODAY(),"Y")

But, the result is 15/04/1900.

Please correct me how I am wrong.

Thanks.