IF Statment Help

[Morsey]

Hello I am trying to create an IF Statment that creates a status based on date permeters, an i am coming across an issue

This is my table example

Start Date	End Date	Status
25/06/2015	29/06/2015	Preperation
		Active
		History

<tbody>
</tbody>

My Logic is this I need the status to report based on where the case is at today().

If today is less than the start date = Preperation
If today is between the start date and end date = Active
If today is greater than the end date = History

the problem I am encountering is that the end date can be a blank cell and causes the formula to show "FALSE", I am not sure how to resolve this.

Here is my formula

=IF(ISBLANK(L3),IF(TODAY()<=K3,"Preperation",IF(AND(TODAY()>=K3,TODAY()<=L3),"Active",IF(ISBLANK(L3),"Active",IF(TODAY()<=K3,"Preperation",IF(AND(TODAY()>=K3,TODAY()<=L3),"Active"))))))

any help would be greatly appreciated!

 

[AlanY]

depends on what will be the status with no end date.

 

[AlanY]

.....................

 

[AlanY]

don't know what happened to the last post, try this

Excel 2012
	K
11	Active
Sheet1

Cell Formulas
Range	Formula
K11	=IF(TODAY()OR(TODAY()<=L3,ISBLANK(L3)),"Active","History"))

 

[Morsey]

don't know what happened to the last post, try this

Excel 2012

	K
11	Active

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula K11 =IF(TODAY()<K3,"Preperation",IF(OR(TODAY()<=L3,ISBLANK(L3)),"Active","History")) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you, this works! Really appreciated!!!

 

[AlanY]

you're welcome