Hi,

The undocumented DATEDIF function has the following form:

DATEDIF(StartDate,EndDate,Unit)

Where Units are on the left in the table below and their results on the
right. Note that the Unit must be quoted - "y" for example.

y Whole years between two dates
m Whole months between two dates
d Whole days between two dates
md Number of days between two dates ignoring months
ym Number of months between two dates ignoring years
yd Number of days between two dates ignoring years

=DATEDIF(A1,A2,"Y") returns the number of whole years between the dates in
cell A1 and A2
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"tonyalt3" wrote:

I would like to calculate how many months it has been from one cell to
another. Example: cell a1 has 1/5/2009 and cell b1 has 5/17/2009. Is
there a function for this?