A | B | C | D | E | F | |
1 | Initially Approval | Issued | Projected Begin Date | Projected End Date | Final Approval | Today's Date |
2 | 23 Jul 18 | |||||
3 | Yes | No | 22 Jun 18 | 10 Nov 18 | Yes | |
4 | Yes | Yes | 25 Aug 18 | 10 Nov 18 | Yes | |
5 | No | Yes | 18 Jul 18 | 10 Nov 18 | No | |
6 | No | No | 2 Jul 18 | 10 Nov 18 | No |
<tbody>
</tbody>
The formula I have alreadyhave for cell E6 is: =IF(C6<=$F$2>D6,IF(B6="YES","NO","YES"),IF(B6="NO","YES","NO"))
Any help would be appreciated.