Excel - Date formula issue

December 2016




Issue


I need an excel formula that tells me if a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) but I keep getting #name errors.
If it's any help, the cell with the date (I12) is retrieving it via a vlookup function and is not just a date entered manually.

The only other value in I12 will be a #N/A error. Is it possible to use ISNA to return no if true and yes if false?
Could anyone help?

Solution


Try this:
=if(isnumber(I12),"yes","no")  

Note


Solved by JD

Related :

This document entitled « Excel - Date formula issue » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.