Forum Discussion

lkorahais's avatar
lkorahais
Copper Contributor
Nov 17, 2021
Solved

Summing the algorithm datedif

HELLO I HAVE A PROBLEM OF CALCULATION! I USED THE FUNCTION DATEDIF TO FIND THE DIFFERENCE BETWEEN MANY DIFFRENT DATES AND THE RESULT IS THESESONE " .... years...months..days " FOR EACH CALCULATE WHIC...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 17, 2021

    lkorahais 

    Could you please illustrate on small sample file what you try to do.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 17, 2021

lkorahais 

Could you please illustrate on small sample file what you try to do.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 17, 2021

      lkorahais 

      Thank you. Formulae could be

      SUM TRUE:
=SUMPRODUCT( ($B$2:$B$6 - $A$2:$A$6)*$C$2:$C$6 )

SUM FALSE:
=SUMPRODUCT( ($B$2:$B$6 - $A$2:$A$6)*NOT($C$2:$C$6) )

SUM TRUE/FALSE:
=G2+G3
      • lkorahais's avatar
        lkorahais
        Copper Contributor
        Nov 17, 2021

        Thank you for your help but no it didn't help because maybe i didn't expain well.By using the datedif command i have the dates D2:D6. At the next table G2 I want the result of the sum the TRUE dates which at the example are D2 ,D4 but to show the result in years Months and Days. the same at the G3 I want the result of the sum the FALSE dates D3,D5,D6 and shown as years monts and days as shown at the example, and finaly at G4 I want to sum all the TRUE - FALSE dates shown in years Monts and days together.

        SergeiBaklan