Date Formula

[charlie]

Column A has an investment date
Column B has a redemption date
I need column C to tell me how long the investor was in the fund.

I know I can subtract column A from C and divide by 365 days, but isn't
there a more direct formula for this?

 

[Ron Rosenfeld]

Column A has an investment date
Column B has a redemption date
I need column C to tell me how long the investor was in the fund.

I know I can subtract column A from C and divide by 365 days, but isn't
there a more direct formula for this?

If you don't divide by 365, you will have the number of days the investor was
in the fund. How more direct do you need to be?
--ron

 

[charlie]

I thought there was a "better" formula. This is the simple version of what I
need to do and I thought there was a better formula for subtracting cells
with dates.

 

[willwonka]

Take a look at CPearson's site..

http://www.cpearson.com/excel/datedif.aspx

 

[TomPl]

Try this formula:

=YEAR(B1-A1)-1900&" years "&MONTH(B1-A1)&" months "& DAY(B1-A1)&" days"

 

[charlie]

That's exactly what I needed. Thanks!

Try this formula:

=YEAR(B1-A1)-1900&" years "&MONTH(B1-A1)&" months "& DAY(B1-A1)&" days"

 

[charlie]

That's exactly what I needed. Thanks!

Try this formula:

=YEAR(B1-A1)-1900&" years "&MONTH(B1-A1)&" months "& DAY(B1-A1)&" days"