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.