Formula of Embarrassment.

[HarleyDog]

(04-08-2022, 09:17 AM)XenoMorph Wrote: Would it be better to just use 52 weeks instead of 4*12 (48)     of course your work may be different

Assuming the 5 = days
4= weeks
12= months

=SUM(  ((I30*5*52)/(E26+F27))/222 )

Nailed it. And yes, it would be better and that's exactly what my boss asked me as we were both laughing. In a million years I can't even think of why I would have typed it that way, but I know I did. So not only did you figure out what the formula meant, you also figured that by doing it the way I did I was missing 4 weeks. Good Job!