Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula that will subtract March from June returning only the number
of months. For example: 6/1/08-3/1/08=3 6/1/08-3/15/08=3 6/1/08-4/15/08=2 6/1/08-5/15/08=1 However, 6/1/08-6/1/08 also need to = 1 What I have right now is 6/1/08 in cell B2 and the date to subtract in cell B7 with this formula: SUM(MONTH(B2)-MONTH(B7)) I get the result that I need with all of the above except for when using 6/1/08 in cell B7. How can I modify the formula so that any time that date is used it will also return a 1? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
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) | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
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) |