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