psthink
01-28-2021, 06:08 AM
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!
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!