Hi,

It's done with subtratction and format the cell as general. For example with
your constant date in C1 and your earlier dates in column A in B1 try:-

=$c$1-A1

Drag down.

Mike

"Not Excelerated" wrote:

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