Bls: ]] XL-mania [[ Mencari umur

 

Dear Raymond

Menggunakan Formula DATEDIF saja

saya kasi Guide nya untuk Formula ini ya :

=DATEDIF(Date1, Date2, Interval)

Where:
Date1 is the first date,
Date2 is the second date,
Interval is the interval type to return.

If Date1 is later than Date2, DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a valid date, DATEDIF will return a #VALUE error.
The Interval value should be one of

Interval	Meaning	Description
m	Months	Complete calendar months between the dates.
d	Days	Number of days between the dates.
y	Years	Complete calendar years between the dates.
ym	Months Excluding Years	Complete calendar months between the dates as if they were of the same year.
yd	Days Excluding Years	Complete calendar days between the dates as if they were of the same year.
md	Days Excluding Years And Months	Complete calendar days between the dates as if they were of the same month and same year.

---

Dari: Raymond Adry <Raymond.Adry@vico.co.id>
Kepada: XL-mania@yahoogroups.com
Dikirim: Kamis, 24 Januari 2013 9:07
Judul: ]] XL-mania [[ Mencari umur

 

Mohon bantuannya bagaimana menampakkan umur dari tanggal lahir seseorang

Seperti pada table dibawah ini

No.	Nama	No Pegawai	Tanggal lahir	Umur
1	Herry C Pelealu	01575	23-Jan-60		<-- pada kolom ini yang ditampilkan adalah umurnya =  52
2	Marthen Mantiri	01573	23-Mar-55
3	Supriyono	04621	27-Mar-63
4	Yusak Bulo'	01548	5-Jul-57
5	Djaelani	01244	2-Jan-59
6	Mudjib	01156	12-May-56

 

 

Terima kasih banyak

 

 

Wasalam

Raymond AR

Northern Area

Disclaimer:
The contents of this email, together with its attachments, may contain confidential information belong to Virginia Indonesia Co., LLC ("VICO") and Virginia Indonesia Co., CBM Limited  ("VICO CBM"). If you are not the intended recipient, please notify the sender immediately and delete this e-mail from your system, and you should not disseminate, distribute, copy or otherwise use this email or any part thereof.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (6)

Recent Activity:

• New Members 60

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Merry Christmas. May God bless you and your family...             |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___