terima kasih atas bantuannya Mr. Kid dan mas Lukman Jaya terus ....!
2015-07-15 12:30 GMT+08:00 lkm jktind [email protected] [belajar-excel] < [email protected]>: > > > 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 >>> >>> >>> >> > >

