| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using DATEDIF how do I add another month of each date fall on same
I am using the following
=DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. In case it helps I am trying to figure out how far behind an account is, and if the dates are the same a payment was not made and one more payment would be due. Any help would be great! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using DATEDIF how do I add another month of each date fall on same
=IF(DATEDIF(C6,C5,"m")=0,1,DATEDIF(C6,C5,"m"))
"kmt1984" wrote: I am using the following =DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. In case it helps I am trying to figure out how far behind an account is, and if the dates are the same a payment was not made and one more payment would be due. Any help would be great! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using DATEDIF how do I add another month of each date fall on same
Try
=MAX(1,DATEDIF(C6,C5,"m")) Mike "kmt1984" wrote: I am using the following =DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. In case it helps I am trying to figure out how far behind an account is, and if the dates are the same a payment was not made and one more payment would be due. Any help would be great! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using DATEDIF how do I add another month of each date fall on same
"kmt1984" wrote:
=DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. If you mean that literally ("only ... if the dates are exactly the same"), then: =datedif(C6,C5,"m") + (C6=C5) If you really mean "only if the dates are in the same month": =max(1, datedif(C6,C5,"m")) ----- original message ----- "kmt1984" wrote in message ... I am using the following =DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. In case it helps I am trying to figure out how far behind an account is, and if the dates are the same a payment was not made and one more payment would be due. Any help would be great! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using DATEDIF how do I add another month of each date fall on
Thank you the first was exactly what I was looking for!!
Thanks again! "JoeU2004" wrote: "kmt1984" wrote: =DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. If you mean that literally ("only ... if the dates are exactly the same"), then: =datedif(C6,C5,"m") + (C6=C5) If you really mean "only if the dates are in the same month": =max(1, datedif(C6,C5,"m")) ----- original message ----- "kmt1984" wrote in message ... I am using the following =DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. In case it helps I am trying to figure out how far behind an account is, and if the dates are the same a payment was not made and one more payment would be due. Any help would be great! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding a month upwards , after using an =datedif fomula | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Month (datedif) to 1 decimal | Excel Worksheet Functions | |||
| Datedif incorrect month count - February problem?? | Excel Worksheet Functions | |||
| DATEDIF calculates a month off | New Users to Excel | |||
Linear Mode
