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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sept.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]9/1/2018[/TD]
[TD]9/2/2018[/TD]
[TD]9/3/2018[/TD]
[/TR]
[TR]
[TD]Revenue
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shipments[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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