| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Hybrid Mode
