Counting Days or Months

N

Not Excelerated

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
 
M

Mike H

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
 
P

Peo Sjoblom

For days it's a simple subtraction

=current_date-past_date


format result as general


for months


=DATEDIF(past_date,current_date,"m")
 
Top