IF Formula for Aging Reports

[fx297]

Hello,
I am trying to figure out how to write an aging formula with conditional formatting for a column that will notify the user how long the report is open before they go to a different column and change the status of the report "closed". I am trying to add now extended if the report needs extra time to resolve.
So far
I have
=IF(H4="Open",TODAY()-F4,M4-F4)
H is the status column OPEN, CLOSED, EXTENDED
I want to include CLOSED and EXTENDED in the formula but dont know how
any help is appreciated

 

[Joe4]

Welcome to the Board!

You can do what with a nested IF statement.
See: MS Excel: How to use the Nested IF Functions (WS)