Counting Days or Months

[Guest]

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

 

[Guest]

Hi Chris,

Try function days360()

 

[Guest]

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

 

[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")