Excel returns FALSE sometimes.... why

[Solved/Closed]
Report
Posts
1
Registration date
Monday June 30, 2014
Status
Member
Last seen
June 30, 2014
-
 plato -
I'm using this formula to show the persons age based on date of birth. In some cases it works but in others it returns FALSE. If I change the date of birth it is a hit and miss as to whether it displays the age or FALSE. I need it to reflect the age all the time and leave the cell blank if no date of birth is displayed. Any assistance appreciated.

=IF(ISBLANK(F2),"",IF(MONTH(TODAY())>MONTH(F2),YEAR(TODAY())-YEAR(F2),IF(AND(MONTH(TODAY())=MONTH(F2),DAY(TODAY())>=DAY(F2)),YEAR(TODAY()))))

1 reply

Posts
22
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014

Hi

the false because of there are missing action

=IF(ISBLANK(F2),"",IF(MONTH(TODAY())>MONTH(F2),YEAR(TODAY())-YEAR(F2),IF(AND(MONTH(TODAY())=MONTH(F2),DAY(TODAY())>=DAY(F2)),YEAR(TODAY()), "??????")))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you very much