If condition with blank cells

[xcracer41]

How do I return a value if one cell contains a date value and the cell above it is blank?

[alansidman]

What is your criteria?
What answer if criteria is True?
What answer if criteria is False?

[xcracer41]

I have a list of dates and next to the dates and I want an equation to only return the top date of the list. So it would be something like =IF(AND(A2=*a date*,A1=*blank cell*),A2,"")

[AliGW]

Maybe this:

=IF(AND(A2=DATE(2017,10,30),A1=""),A2,"")

[xcracer41]

Not looking for a specific date, just if it contains a date

[AliGW]

A date as opposed to what? What other type of value could be in the cell?

[xcracer41]

As opposed to a blank cell...

[benishiryo]

welcome to the forum. the unfortunate part is that Excel recognizes date as integers & time as decimals. to verify, type in 1jan2013 in A1. and 12 pm in B1. Format both cells to General. you will see that A1 is 41275 (meaning 41,275th day from 1 Jan 1900) & B1 is 0.5 (1/2 a day).

since you can't verify if it's a date, the best you can do is to check if A2 is a number.
=IF(AND(ISNUMBER(A2),A1=""),A2,"")

or if you are certain it's between a certain date (2010 to 2017 for eg), then:
=IF(AND(A2>=--"1jan2010",A2<=--"31dec2017",A1=""),A2,"")

or if you say it's as opposed to a blank cell (no other possibilities of numbers or text), then:
=IF(AND(A2<>"",A1=""),A2,"")

[xcracer41]

Perfect! Thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Harshaman]

PL ignore . I have posted this in forum.

Request your guidance for counting blank cells with multiple conditions. I have a column "E" with town names and another column "F" with type of town and I want to count the number of blank cells in column "G" against the town and type.