Forum Discussion
Choosing best function
I'm relatively new to using functions and formulas. I have a question regarding which type of function/ formula I should use for the following scenario. Scenario: A sporting goods store track...
For this scenario, you would want to use a combination of functions to calculate the days between sales orders for each item. Firstly, you can utilize the DATEDIF function to calculate the difference in days between consecutive sales orders for each item. Then, you would need to employ functions like IF, INDEX, and MATCH to handle varying numbers of sales orders per item. By using these functions together, you can dynamically calculate the days between sales orders for each item regardless of the total number of sales orders they have.