Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Rollup Fields with Dates & Average

105 1
Showing results for 
Search instead for 
Did you mean: 

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!)


1 Reply 1

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