countif help

[masond3]

Hey guys

I am hoping you can help


I would like like a formula , to see what stage each row is at , populate that stage within column w, and also how many days it has been stuck at that particular stage from the date stamps in column g-k


also, I don’t need the formula to applied to “opportunity lost, or live transaction”

so eg, row 4,

is approved by risk

so In a new column I would expect it to say, approved by risk, and the number of days it has sat at the stage for , so in this instance its around 80. But I need networking days if possible

[dilipandey]

Hi masond3

How you are calculating number of days i.e., 80 days for row#4 ?

Regards,
DILIPandey

<click on below 'star' if this helps>