Pak Roy.
B7 =IF(DATE(YEAR(B2)+45;MONTH(B2);DAY(B2))<DATE(YEAR(B3)+B5;MONTH(B3);DAY(B3));"Ditolak";"Diterima") Salam Lukman 2015-07-14 18:19 GMT+07:00 'Mr. Kid' [email protected] [belajar-excel] < [email protected]>: > > > Hai Roy, > > File terlampir dengan fungsi DateDif, EDate, Today, dan YearFrac > > Regard, > Kid > > > 2015-07-14 18:07 GMT+07:00 'Roy@ld' [email protected] [belajar-excel] < > [email protected]>: > >> >> >> Dear para sesepuh Excel >> >> Mohon bantuannya..! >> >> Bagaimana saya bisa mengetahui usia sebagaimana file terlampir >> >> Atas bantuannya disampaikan terima kasih >> >> >> > >
re_seberapa tua saya.xlsx
Description: MS-Excel 2007 spreadsheet
