hi all..
i have formula to calculate age of students cut off per 1 july 2016
this formula working in 2015 but not working in 2016, how to fix it 2016, 2017, etc...
how to modified well..![]()
=INT(DATEDIF(L26;--"01-JUL-2015";"M")/12)&" tahun "&ROUND(MOD(DATEDIF(L26;--"01-JUL-2015";"M")/12;1)*12;2)&" bulan"
any helps, thanks in advance..
john mustofa
Bookmarks