Date Average

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?
 
Back
Top