Don't calculate null/blank date column

[Anonymous]

I've searched and tried severad methods but can't get this scenario to work.  I'm looking to use conditional formatting on a date column but the best solution I could come up with is creating a new column that counts the following:

Target Date < Today = IF ( [Target Date Column] < Today( ), 1, 0)

This gives me a new column of 1's and 0's that I can use for conditional formatting.  

The problem:

In [Target Date Column] there might not be a date which will show as null which I know is considered as blank.  How do I get the above statement to not include anything that is blank?

[V-pazhen-msft]

@Anonymous 

You can use nested IF, something like:

Target Date < Today = IF ( [Target Date Column] = Blank() , Blank(), IF ([Target Date Column] < Today( ), 1 ,0)

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

You can use IsBlank(TargetDateColumn) or If( TargetDateColumn=Blank(), TrueCondition Expression, FalseCondition Expression).

[Anonymous]

Thanks but this only lets me know if the column is blank. What I'm trying to do is have it skip over anything that is blank.  Only look at fields that have a value present or in this case, not blank. So anything that is not blank in the TargetDateColumn that is < today(), then false, else true.

TargetDateColumn that is NOT blank AND is < Today( ), then 1, else 0 - leave the blank TargetDateColumn values as blank.  This way I only see a "1" value if it's < than today's date and a "0" value if it's > than today's date.  The rest remaing blank untile a value is added to the TargetDateColumn.

[Tahreem24]

@Anonymous ,

Try something like below:

Column = IF(AND(ISBLANK(Sheet10[Date]),Sheet10[Date]<TODAY()),1,0)