Excel How to calculate in excel number of open actions that expired (older then today)

Joined
May 26, 2017
Messages
1
Reaction score
0
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
 

Attachments

  • FullSizeRender.jpg
    FullSizeRender.jpg
    684.5 KB · Views: 103
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top