Excel - Formula to stop counting based on another cell

[psthink]

Hi all!

I need some help if someone could assist would appreciate!

I current have a formula in cell M3 which is - =TODAY()-B3

B3 is the date the information was input into the system therefore giving me the number of days that specific query has been open

Column N is 'Status' with a drop down for: Pending, Accepted, Declined


I'd like cell M3 to stop the count if N3 changes from "Pending" to their Accepted or Declined

Is this possible? I've tried looking online to no avail!

Thank you in advance!

[Bob Phillips]

Isn't it just

=IF(N3<>"Pending",TODAY()-$B3,"")

[psthink]

Thank you Bob! I'm a beginner with Excel at the minute so still learning, that almost worked just had to change <> for =

Thank you for your help I appreciate it