Date Formula
 

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?

Date Formula
 

On Thu, 3 Jul 2008 13:16:01 -0700, charlie
wrote:

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

Date Formula
 

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.

"Ron Rosenfeld" wrote:

On Thu, 3 Jul 2008 13:16:01 -0700, charlie
wrote:

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

Date Formula
 

Take a look at CPearson's site..

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



On Jul 3, 3:16*pm, charlie wrote:
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?

Date Formula
 

Try this formula:

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

"charlie" wrote:

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?

Date Formula
 

That's exactly what I needed. Thanks!

"TomPl" wrote:

Try this formula:

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

"charlie" wrote:

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?

Date Formula
 

That's exactly what I needed. Thanks!

"TomPl" wrote:

Try this formula:

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

"charlie" wrote:

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?