Automatic Date Updating

[Wshot12]

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

Sept.
	9/1/2018	9/2/2018	9/3/2018
Revenue
Shipments
Weight

<tbody>
</tbody>

 

[James006]

Hi,

If we assume you are using cell A3 ... to type in TEXT ... i.e September, October, etc ....

In cell B5, you can test following Formula :

=DATE(2018,MONTH(1&A3),1)

Hope this will help