Hi Ron,

Am Wed, 25 Apr 2018 13:46:11 -0700 (PDT) schrieb Ron George:

Thanks a lot. I put the "C2-1" bit there make it understand that the upper limit of sigma function is n-1 where n is the day on any row. If n = 3, C2-1 = 1.

Also, do you think my formula as a whole is correct?

my understanding for your formula is a bit different.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgcxMl0ftNOJuVY6Duw


Regards
Claus B.
--
Windows10
Office 2016