Good day all.
I am having a difficult time with getting a formula that would provide me with my answer for the following. I have the following in the columns mentioned. basically i need a formula that will calculated the days between today and the date within column b, when it has that number it has to return text into column C according to the last column in the rules mentioned below.
basically, if it says Lead( for instance) and the days difference between column B and today's date is less than 7, it has to return " Active"
column A Column B Column C
Lead Date( for Example 2nd of May 2014) answer
The rules
Category Day Difference Answer/comment
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I am having a difficult time with getting a formula that would provide me with my answer for the following. I have the following in the columns mentioned. basically i need a formula that will calculated the days between today and the date within column b, when it has that number it has to return text into column C according to the last column in the rules mentioned below.
basically, if it says Lead( for instance) and the days difference between column B and today's date is less than 7, it has to return " Active"
column A Column B Column C
Lead Date( for Example 2nd of May 2014) answer
The rules
Category Day Difference Answer/comment
Lead | <7 | Active |
Lead | Between 7 and 14 | Expires this week |
Lead | >14 | expired |
Potential | <83 | Active |
Potential | Between 83 and 90 | Expires this week |
Potential | >90 | Expired |
Imminent deal | <83 | Active |
Imminent deal | Between 83 and 90 | Expires this week |
Imminent deal | >90 | Expired |
On Hold | <83 | Active |
On Hold | Between 83 and 90 | Expires this week |
On Hold | >90 | Expired |
Opportunity | <83 | Active |
Opportunity | Between 83 and 90 | Expires this week |
Opportunity | >90 | Expired |
<colgroup><col><col><col></colgroup><tbody>
</tbody>