The problem with that is that it is incapable of giving a zero for the
number of months or the number of days.

DATEDIF is a much better bet.
--
David Biddulph

"Jarek Kujawa" wrote in message
...
=AVERAGE(TODAY()-A1:A4)

aray entered (CTRL+SHIFT+FORMULA), formatted as "yy-mm-dd"

results with "17-12-19" as today

on 7/27/2008 it will result with "17-12-30"

hope this makes sense