Hello All,
I am currently using a DOB against todays date to figure out the age of a person. I am using =INT((F$4-E38)/365.25) so F$4 is todays date. In the blank rows it is given me the answer 111. Can you please tell me if there is a way i can change this unused row showing 111 to showing nothing at all until the row has the information? I thought about using =IF(F47<100,F47," ") but not sure of a way of adding the two formulars together in one output cell without creating a circular formula.
Appreciate any help. New and learning fast
Lily
Bookmarks