Forum Discussion
Calculating age, with a hitch
Hello, I am a new user, I am using the format in the attached screenshot to fill in a patient's age on their admit day. It works fine with one glitch. As you see when the form comes up blank, the DOB...
About the age: change the formula to
=IF(OR(I1="",E1=""),"",DATEDIF(I1,E1,"Y"))
This will make the formula return a blank if I1 or E1 has not been filled in.
