Excel - Date formula issue

January 2017




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


Published by aakai1056. Latest update on March 20, 2012 at 12:27 PM by aakai1056.
This document, titled "Excel - Date formula issue," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).