Hello,
In Excel 2016 trying to calculate number of actions that expired (older than today's date in column S) and not closed (column T=0 or column W= open).
H | S | T | W
Log Date | Target Completion Date | Date Closed | Task Status
1 04-Feb-15 | 4-Mar-15 | 01-Jan-15 | CLOSED
2 04-Feb-15 | 4-Jun-15 | | OPEN
Any advice would be really helpful.
Thank you,
Nat
In Excel 2016 trying to calculate number of actions that expired (older than today's date in column S) and not closed (column T=0 or column W= open).
H | S | T | W
Log Date | Target Completion Date | Date Closed | Task Status
1 04-Feb-15 | 4-Mar-15 | 01-Jan-15 | CLOSED
2 04-Feb-15 | 4-Jun-15 | | OPEN
Any advice would be really helpful.
Thank you,
Nat
Attachments
Last edited: