Finds the average (mean) of an array of numbers or dates.
Syntax
AVG([x,x,x,x…])
Parameters
x = a number or date that you wish to be included in the array that will be averaged.
Type of Data Returned
A number or date will be returned depending on input.
Examples
AVG([1,2,3,4]) will return 2.5
AVG([10,20,30,40]) will return 25
Returning the average of Project Start (ProjS) and Project End (ProjE) which are 2 date fields.
AVG([ProjS, ProjE]) will return the average of those two dates for that item.