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? |
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? |
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? |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com