Hi
I'm doing a summary table for the data that I have. See sample below. I was just wondering if there's a way to make the dates change automatically depending on the selected setting (first box) without having to make a really long if statement. For example, the setting now is for September and it shows the dates for September, if I changed it to October, it would show the dates for October. Is there a way to do that? Any help would be very much appreciated.
Sean
<tbody>
</tbody>
I'm doing a summary table for the data that I have. See sample below. I was just wondering if there's a way to make the dates change automatically depending on the selected setting (first box) without having to make a really long if statement. For example, the setting now is for September and it shows the dates for September, if I changed it to October, it would show the dates for October. Is there a way to do that? Any help would be very much appreciated.
Sean
Sept. | |||
9/1/2018 | 9/2/2018 | 9/3/2018 | |
Revenue | |||
Shipments | |||
Weight |
<tbody>
</tbody>