Forum Discussion
Help with a Form and Formulas
Hello Team, I have a challenge that I hope the gurus on this forum can help me solve. Challenge 1: I have created an Excel form to be used by a group of parents, including myself, on mobile devices...
I think you have to calculate the totals for each of the day of the week separately.
For example, for breakfast club on Monday:
=IF(D21="", 0, (NETWORKDAYS.INTL($K$12, $K$15, "1011111")-NETWORKDAYS.INTL($K$13, $K$14, "1011111"))*D21)
And for Tuesday:
=IF(D22="", 0, (NETWORKDAYS.INTL($K$12, $K$15, "1101111")-NETWORKDAYS.INTL($K$13, $K$14, "1101111"))*D22)
etc.