Yet Another Date Formula Question!


#1

Hey everyone,

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.


#2

You have the function DATETIME_DIFF that is just for that. The Investment Declined should be a date field. I would use nested IFs to check which is the last date registered:

IF(
	{Investment Declined},
	DATETIME_DIFF(
		{Contacted Date},
		{Investment Declined},
		'days'
	),
	DATETIME_DIFF(
		IF(
			{Second Meeting},
			{Second Meeting}
			IF(
				{Fist Meeting},
				{Fist Meeting},
				{Contacted Date}
			)
		),
		TODAY(),
		'days'
	)
)