Hi All,
I am calculating the daily forecast based on the given weekly forecast (Row 3) & daily % breakdown for the corresponding week commencing dates (Row 2).
Below is an example of the large data set and desired output (Row Output).
I have tried using index match and managed to calculate for corresponding dates however, I get 0 for dates which do not match. e.g. 21/01/2025.
Any help in the below will be really appreciated.
I am calculating the daily forecast based on the given weekly forecast (Row 3) & daily % breakdown for the corresponding week commencing dates (Row 2).
Below is an example of the large data set and desired output (Row Output).
I have tried using index match and managed to calculate for corresponding dates however, I get 0 for dates which do not match. e.g. 21/01/2025.
Any help in the below will be really appreciated.