Couple of questions on formulas

  • Thread starter Thread starter bluegirl
  • Start date Start date
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
 
Hi
try
=IF(H371="","Undisclosed",IF(A371="","",DATEDIF(H371,A371,"y")))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate age with an end date 3
Expanding Date formula 1
date of birth age formula 8
Age Formula 4
Help needed 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Update Upon Opening based on DATEIF NOW() 10
How to leave a formula cell blank when it has no calculation to make 9

Back
Top