0

I have a report with data on learning activities of some learners, see sheet here.

They are enrolled in a language learning program and to reach their goal, they have to learn 8 hours per month (sum of hours spent in self study, group classes and 1:1 classes).

I want the value of 8 (H3) to be incremented by 8 at the beginning of every month (B11-B16) to be able to correctly display status in (H4-H7).

I was thinking at something like:

=IF(TODAY()<=B12=C12,C11)

but it seems to be far away from working.

Any idea of how this can be automated?

Thanks a lot! :)

nadiamarra
  • 3
  • 1
  • I'm not totally sure what your goal is. It seems like you are overcomplicating the problem. Anyway, assuming you have your starting day reported in cell B11, try this formula: `=(MONTH(TODAY())-MONTH($B$11)+(YEAR(TODAY())-YEAR($B$11))*12)*8`. – Evil Blue Monkey Mar 25 '23 at 15:34

0 Answers0