Hi, I am trying to fix an issue with my table that causes dates from outside of the current month to display in the table. This is a sheet that I must protect before forwarding it to prevent accidental modification by the user, so they may only modify the orange cells. The screenshot below shows the field where the user enters the current month, after which the table updates according to the month entered.
As seen in the table below, if a month with less than 31 days is entered, the table includes the day from the following month as the 31st day:
Consequently, the date will also display in the following chart, which displays an unwanted "0" entry at the end of the chart, which messes up the trendline when full set of data are entered:
My question is: Is there either a way to set up a rule that omits either the date from the following month, or gets rid of the "0" entry in either the table or the chart?
As seen in the table below, if a month with less than 31 days is entered, the table includes the day from the following month as the 31st day:
Consequently, the date will also display in the following chart, which displays an unwanted "0" entry at the end of the chart, which messes up the trendline when full set of data are entered:
My question is: Is there either a way to set up a rule that omits either the date from the following month, or gets rid of the "0" entry in either the table or the chart?