V
VB
vezerid gave me the following solution to my initial post (copied below),
which works wonderfully, but I forgot to mention 1 other criteria: I need the
formula to put a result in Column S based on the date in Column U (if there
is one), and stop calculating elapsed days as of that date.
vezerid's solution:
=IF(OR(AND(P15=1,TODAY()-R15>30,U15-R15>30),AND(P15=2,TODAY()-R15>45,U15-R15>45)), TODAY()-R15,"")
I am trying to write a conditional formula that calculates the number of days
which works wonderfully, but I forgot to mention 1 other criteria: I need the
formula to put a result in Column S based on the date in Column U (if there
is one), and stop calculating elapsed days as of that date.
vezerid's solution:
=IF(OR(AND(P15=1,TODAY()-R15>30,U15-R15>30),AND(P15=2,TODAY()-R15>45,U15-R15>45)), TODAY()-R15,"")
I am trying to write a conditional formula that calculates the number of days