B
bluegirl
If I want a column to look at a column containing a date, and figure th
persons age at that time, I am using this formula.:
=DATEDIF(H371,A371,"y")
However, I would like to modify this so that if no date is given, i
column H, it will return "Undisclosed", and if no data has been entere
in either column a or h, it shows blank. I know that this is doin wit
,"" but I am not sure where to put it?
Can anyone help
persons age at that time, I am using this formula.:
=DATEDIF(H371,A371,"y")
However, I would like to modify this so that if no date is given, i
column H, it will return "Undisclosed", and if no data has been entere
in either column a or h, it shows blank. I know that this is doin wit
,"" but I am not sure where to put it?
Can anyone help