Excel 2007 : Show Formula for only date

**Jerseynjphillypa** · 06-14-2012, 01:30 PM

I want the formula below to work only if there is a date Enter in the cell. If there is next I want to ignore the formula

=IF(A1="",B1,A1)

**dilipandey** · 06-14-2012, 01:58 PM

Hi Jerseynjphillypa,

=if(c1="","",<your formula>)

Use above formula where I am assuming that cell C1 is to be checked for date.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**dip11** · 06-15-2012, 07:02 AM

What is in the cell if it is not a date?

Since dates in excel are numeric and large numbers and assuming you don't go back to 0AD but stay in the 1990+ range, you could use
=IF(ISNUMBER(A1),A1,B1)

If you have numbers in the cell if it isn't a date but those numbers are fairly small, you can use:
=IF(AND(ISNUMBER(A1),A1>30000),A1,B1)