Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculations
I have to create a formula in excel that takes a date (4-1-2010) and
subtracts another date from it (2-1-2008) and gives me the remainder of months. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculations
How do you define a month difference? 30 days? Calendar months? What
about months with different numbers of days. E.g., how many months between 28-Feb and 31-March. 1? 1+3/30? You need to define how the months should be calculated. At its simplest, just subtract one date from the other and divide by 30. That will give one of several possible answers. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Thu, 8 Apr 2010 13:25:01 -0700, Erika wrote: I have to create a formula in excel that takes a date (4-1-2010) and subtracts another date from it (2-1-2008) and gives me the remainder of months. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculations
See if this is accurate enough for you
A1 = 4/1/2010 B1 = 2/1/2008 C1 = A1 - B1 D1 = ROUND(C1/30,0) or E1 = ROUND((A1-B1)/30,0) D1 and E1 give the same answer, just one step for E1. Jeff "Erika" wrote: I have to create a formula in excel that takes a date (4-1-2010) and subtracts another date from it (2-1-2008) and gives me the remainder of months. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculations
On 8 avr, 22:25, Erika wrote:
I have to create a formula in excel that takes a date (4-1-2010) and subtracts another date from it (2-1-2008) and gives me the remainder of months. *Any ideas? Hello, You can have a look at the Excel DAYS360 function which returns the number of days between 2 days based on a 360 days year. This formula takes 3 parameters : start_date, end_date and a boolean which allows to choose between 2 calculations methods : the american method or the european method, take a look at the Excel Help on this function for more details on this option. Hope this helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Date calculations | Excel Worksheet Functions | |||
Date Calculations before date entered | Excel Discussion (Misc queries) | |||
Date calculations and sum | Excel Worksheet Functions | |||
date calculations | Excel Discussion (Misc queries) | |||
Date Calculations | Excel Worksheet Functions |