Intermittent fasting (IF) refers to various dietary regimens that cycle between a period of non-fasting and a period of total fasting. This study aimed to determine the effects of IF on cognitive function among elderly individuals who practice IF who have mild cognitive impairment (MCI). A total of 99 elderly subjects with MCI of Malay ethnicity without any terminal illness were recruited from a larger cohort study, LRGS TUA. The subjects were divided into three groups, comprising those who were regularly practicing IF (r-IF), irregularly practicing IF (i-IF), and non-fasters (n-IF). Upon 36 months of follow-up, more MCI subjects in the r-IF group reverted to successful aging with no cognitive impairment and diseases (24.3%) compared to those in i-IF (14.2%) and n-IF groups (3.7%). The r-IF group’s subjects exhibited significant increment in superoxide dismutase (SOD) activity and reduction in body weight, levels of insulin, fasting blood glucose, malondialdehyde (MDA), C-reactive protein (CRP), and DNA damage. Moreover, metabolomics analysis showed that IF may modulate cognitive function via various metabolite pathways, including the synthesis and degradation of ketone bodies, butanoate metabolism, pyruvate metabolism, and glycolysis and gluconeogenesis pathways. Overall, the MCI-afflicted older adults who practiced IF regularly had better cognitive scores and reverted to better cognitive function at 36 months follow-up.