=IF(MONTH(NOW())<MONTH(G4),INT(YEAR(NOW())-YEAR(G4))-1,IF(MONTH(NOW())>MONTH(G4),YEAR(NOW())-YEAR(G4),IF(DAY(NOW())>=DAY(G4),YEAR(NOW())-YEAR(G4),YEAR(NOW())-YEAR(G4)-1)))
此公式用于根据出生的年、月、日精确的计算年龄,G4单元格填写的是出生日期
2024-04-04 09:21:11
=IF(MONTH(NOW())<MONTH(G4),INT(YEAR(NOW())-YEAR(G4))-1,IF(MONTH(NOW())>MONTH(G4),YEAR(NOW())-YEAR(G4),IF(DAY(NOW())>=DAY(G4),YEAR(NOW())-YEAR(G4),YEAR(NOW())-YEAR(G4)-1)))
此公式用于根据出生的年、月、日精确的计算年龄,G4单元格填写的是出生日期