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
<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!
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!