Averaging dates

[Anonymous]

Greetings,

  Is there a way to formulate out a way to find that average date from a list of dates based on topic?  For example, I want to look at all of the components that deal with system A and see what the average date of expiration is for those components?  That way I can tell my customer that they need to start getting replacements before a specific date.

Thank you in advance.

[Rick2Foqus · Accepted solution]

Every date behaves like a number on the background. The numbers before the comma correspond with the date, the numbers after the comma with the time. You need to make a number of the date first by using: NUM(Date). 

If you take the average, there will probably be some numbers behind the comma. You can remove those by the function "FLOOR". 

The final function you could use is:

Date(FLOOR(AVG(NUM(DATE))))