| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtract dates
Hi. I need to do an if then formula that applies a
formula if two dates are within 9 months of each other or does not apply the formula if they are 9 months or greater apart. How do I do this? I can't just base it off of a straight # of days X 9 because of the different days in a month. Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
subtract dates
Hi
try (if A1 and A2 stores your dates) =IF(OR(DATEDIF(A1,A2,"m")<9,AND(DATEDIF(A1,A2,"m") =9,DATEDIF(A1,A2,"md" )=0)),your_formula,"") -- Regards Frank Kabel Frankfurt, Germany jrh wrote: Hi. I need to do an if then formula that applies a formula if two dates are within 9 months of each other or does not apply the formula if they are 9 months or greater apart. How do I do this? I can't just base it off of a straight # of days X 9 because of the different days in a month. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TODAY, Subtract a List of Dates from... | Excel Discussion (Misc queries) | |||
| Subtract if dates in the range between 2 dates. | Excel Worksheet Functions | |||
| How to subtract 2 dates to get number of days.....please | Excel Worksheet Functions | |||
| Subtract two dates | Excel Discussion (Misc queries) | |||
| Subtract time and dates with restrictions | Excel Worksheet Functions | |||
Linear Mode
