For days it's a simple subtraction

=current_date-past_date


format result as general


for months


=DATEDIF(past_date,current_date,"m")



--
Regards,

Peo Sjoblom



"Not Excelerated" wrote in
message ...
Hello,

I'm trying to take a column containing past dates (in the format:
MM/DD/YYYY); compare it to a CONSTANT, more current date (e.g.
04/01/2007);
calculate the difference in the number of days (my first choice) or months
(second choice); then populate that result in a corresponding column in
that
same Excel sheet.

Your help is always appreciated and thanks in advance!

Chris