Period of Time Between Two Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that can determine the number of whole months between todays date and the date a house was sold, so I can account for market appreciation. I have the date at the top of the form set up like this =today(), and I have a cell where I enter the date a particular house was sold.

Is it possible to do what I want to do?

Thanks,

--Jim
 
One way

=DATEDIF(start_date,TODAY(),"M")

--

Regards,

Peo Sjoblom


Spike9458 said:
I need a formula that can determine the number of whole months between
Click to expand...
todays date and the date a house was sold, so I can account for market
appreciation. I have the date at the top of the form set up like this
=today(), and I have a cell where I enter the date a particular house was
sold.
 
Peo,

Is there a way to plug in the start_date from a cell where the date has already been entered?

=DATEDIF(start_date,TODAY(),"M")

Thanks,

--Jim
 
.... What format should the start_date be in? I used, for example, 6/24/2003, and in the formula you provided, it returned a number of 1247. I'm not sure what that number is telling me, but it's bigger than 6 months.

--Jim
 
Peo

I figured it out. I used this formula, and it seems to be right

=(((I17*0.1)/12)*DATEDIF(I19,TODAY(),"M")

I17 is the sold price, I19 is the date of the sale. With the assumption that real estate appreciates at 10% in a year, the formula takes the sale price times 10%, divides by 12 (months in a year) and multiplies that number by the number of months since the sale. Sound right

Thanks for your help

--Jim
 
Yes, I tried to illustrate that

=DATEDIF(A2,TODAY(),"M")

where A2 holds the date you want to count the months from
 
Hello Jim,
... What format should the start_date be in? I used, for example, 6/24/2003,
Click to expand...
and in the formula you provided, it returned a number of 1247. I'm not sure what
that number is telling me, but it's bigger than 6 months.

Excel doesn't recognize a date when you enter it. "/" is probably not your date
separator in your Windows settings.

Enter the date as
24 Jun 2003
or
=DATE(2003,6,24)

Currently, it is dividing 6 by 24 by 2003, giving a very small number.

The formula is OK.

Regards,

Daniel M.
 
Back
Top