I’m trying to figure out how to do this formula.
I have 3 columns with various dates (day startup is first contacted, day first meeting is set, day second meeting is set). Clearly these dates are going to be in progressive order.
There’s also another field called “investment declined.”
I’m trying to create a formula that calculates the # of days it took for a startup to either be fully analyzed and declined for investment, or the # of days the startup is currently in the funnel (pulling from the latest date among the 3 columns).
Can anyone help me out here? If you’re a Redditor I’ll give you Reddit gold hahaha.