Forum Discussion

OUWL's avatar
OUWL
Frequent Visitor
6 years ago
Solved

Finding calculation between two dates

I have Two rows that have One Assignee and a One Reviewer,    Assignee - Create Date & Complete date Reviewer - Create Date & Complete date     ECN CT Name Create Complete Role CN-XX...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi OUWL , 

    You could refer to my sample to see wheter it is what you want, if this is not waht you want, please correct me.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

OUWL's avatar
OUWL
Frequent Visitor
6 years ago

dax, sorry the output should be in this example 16.3 average for 12 months and 5.4 average for 3 months.  find the amount of parts process per week.

dax's avatar
dax
Community Support
6 years ago

Hi OUWL , 

If possible, could you please explain how to get the result of "16.3 average for 12 months and 5.4 average for 3 months". I am not familiar with your Excel expression, could you please write the expression of above result(such as (11+22)/(22+33))?

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • OUWL's avatar
    OUWL
    Frequent Visitor
    6 years ago

    dax

    Sumifs:

    Old Part Count,MM Complete Date > today-365: 294

    /

    Material Master,MM Complete Date > today() -365: 90*5

     

    (294/90)*5

     

    Regards,

    Reece

     

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi OUWL , 

      You could refer to my sample to see wheter it is what you want, if this is not waht you want, please correct me.

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.