Finds the average (mean) of an array of numbers or dates.

 

Syntax

 

AVG([x,x,x,x…])

 

Parameters

= 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.