Lookup Field to Gantt with Multiple Start & End Da...

[Raphael1]

Hi all,

I am trying to extract the mean/average of a set of dates through roll-ups. I am able to calculate the min or max date through the use of MIN(values) or MAX(values), but AVERAGE(values) returns NaN.

Any suggestions? (thanks in advance!)

[kuovonne]

AVERAGE(values) does not work with date fields.
Can you explain how you want to calculate an average date?