Subtracting DateDif functions from each other

[DaveBre]

Hello all, I'm having some issues subtracting one set of DateDif formulas's from another.

The formula below works fine in adding a number of date ranges together to output the correct answe in X Years X Months and X days, however I need to subtract a diffrent range of dates and time and the formula below doesn't work and I'm unsre why.

Any help to get this working would be appreciated.

Thanks

David

This works:
=DATEDIF(B242,B242+((((C245-B245)+(C244-B244)+(C243-B243)+(C242-B242)))),"y")&" years"&DATEDIF(B242,B242+((((C245-B245)+(C244-B244)+(C243-B243)+(C242-B242)))),"yM")&" month"&DATEDIF(B242,B242+((((C245-B245)+(C244-B244)+(C243-B243)+(C242-B242)))),"MD")&" days"



This doesn't work:
=DATEDIF(B242,B242+((((C245-B245)+(C244-B244)+(C243-B243)+(C242-B242))))-DATEDIF(B247,B247+(((((C251-B251)+(C250-B250)+(C249-B249)+(C248-B248)+(C247-B247))))),"y")&"years"&DATEDIF(B242,B242+((((C245-B245)+(C244-B244)+(C243-B243)+(C242-B242))))-DATEDIF(B247,B247+(((((C251-B251)+(C250-B250)+(C249-B249)+(C248-B248)+(C247-B247))))),"yM")&"month"&DATEDIF(B242,B242+((((C245-B245)+(C244-B244)+(C243-B243)+(C242-B242))))-DATEDIF(B247,B247+(((((C251-B251)+(C250-B250)+(C249-B249)+(C248-B248)+(C247-B247))))),"MD")&" days"

 

[cyrilbrd]

Duplicate of http://www.mrexcel.com/forum/excel-...edif-x-years-x-months-x-days.html#post3614063

Is this related to your previous post?
Please give sample data, I am not quite sure what you are trying to do as the first statement requires an interval (d,m,y...) and you missed that part...