I have an excel spreadsheet where I need to calculate due dates daily. I have four categories, Overdue, Not Due, No Plan. I have an if statement for this and it works. =IF(ISBLANK(B2),"No Plan",IF(B2<TODAY(),"Overdue","Not due"))
My problem is that I also want to split the no plan into 2 categories. You only need a plan after 30 days of awareness. So I would like to have No Plan, and Plan not Required (if it's less than 30 days from Awareness date - column C).
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
My problem is that I also want to split the no plan into 2 categories. You only need a plan after 30 days of awareness. So I would like to have No Plan, and Plan not Required (if it's less than 30 days from Awareness date - column C).
<tbody> </tbody> | |||||||||||||||||
I feel like I might be asking for too much but any help will be appreciated. Thanks | 1/25/2016 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>