I would like to know a formula to determine the number of times that the number charts will appear

Hi @GERSON,

If I understand the issue clearly, following should solve your problem:

This is how it looks when nothing is selected in ENKETO:

This is how the end of form looks when February (28 days) is selected in ENKETO:

This is how end of form looks when any month with 30 days is selected in ENKETO:

This is how end of form looks when any month with 31 days is selected in ENKETO:

This is the survey sheet:

And this is the xlsx of the form where you can change things according to your needs:
Month - Day.xlsx (10.7 KB)

Note: This solution will not cover when there is a leap year (where February has 29 days) because this is a choice list of months. Keep in mind if you need to cover leap years aswell.

1 Like