IF ISNUMBER formula not working for two date fields

[csenor]

Hello all. I need to calculate Deceased Date in a list of about 1000 records. I have birthdates and deceased dates if the person has passed away. Not everyone in my list has passed away. My logical test is not working properly and I don't know why. There are instances where I only know one of the dates and not both. In that case, I don't want a calculation. As much as I can tell, my columns are formatted as dates, because I can filter by date using the dropdown boxes. I added a column1 below and I get a FALSE answer to indicate the DOB cell is not a number, yet I get an age calculation of 117.

Any help would be appreciated.

=IF(AND(ISNUMBER([@[Deceased Date]]),([@DOB])),ROUND(([@[Deceased Date]]-[@DOB])/365,0),"")

 

[JB2020]

It looks like there is no function surround the ([@DOB]) part, could that be the problem?

 

[csenor]

It looks like there is no function surround the ([@DOB]) part, could that be the problem?

It was. As soon as I posted it, I figured it out. That's how it usually works. I wish there was an undo post button. Thank you for responding.