Date Average

[Guest]

I have three date fields: DATE1, DATE2 and DATE3. I would like to do the
following:

1. Find the difference between each date and current date.
2. Convert the differences into numbers.
3. Average the three values.
4. The result in step # 3 will be in calculated field known as RANK.

I will highly appreciate your assistance ladies and gentlemen.

 

[Guest]

Actually I used the following for step 1 and 2 and it worked.
=DateDiff("yyyy",[DATE1],Now())+Int(Format(Now(),"mmdd")<Format([DATE1],"mmdd"))

Now if I repeat the above for DATE2 and DATE3; how will I combine the value
from the three calculated fields to find the average that now will become the
RANK?