IF statements using dates

[KVR1980]

Hello, looking for some help to get the below IF formula working. In cell A3 I was hoping the cell would return "Future" because C3 isn't populated, but it looks like even though C3 is empty its reading it as 01/01/1900. Does anyone know how to get around this, thanks in advance?

 

[Joe4]

That is because a blank is the same as 0, and dates are actually stored as numbers in Excel (the number of days since 1/0/1900 - change any date to General format and you can see this).
So, do a check like:

=IF(C3=0,"Live",...

 

[KVR1980]

Thanks for that logic it makes sense. However Im struggling to write the formula because if cell C3 is blank then the returned value could either be 'Future' if the date in cell B3 is >today or 'Live' if B3 <today.

 

[Sergius]

Is this right for you?

=IF(C16=0;"Future";IF(C16<TODAY();"Historial";"Live"))

 

[Joe4]

Is this what you are looking for?

=IF(AND(C3<TODAY(),C3>0),"Historical",IF(B3>TODAY(),"Future","Live"))

 

[KVR1980]

This is exactly what I was looking for, thanks so much Joe.

 

[KVR1980]

Is this right for you?

=IF(C16=0;"Future";IF(C16<TODAY();"Historial";"Live"))

Thanks for helping Sergius, Joe's formula below did the trick for me

 

[Joe4]

You are welcome.
Glad we were able to help!