Unhiding range of columns via dropdown

[Mr Zero]

Hello,

I am trying to create a sales spreadsheet for employees that has daily sales listed for each day of the year. Column headers would be each day's date. I would like to ONLY display and sum certain two week periods of the year based on a dropdown. I do not want dates outside the selected periods to be shown or be included in the period total. The sums should be under (period total) and (ytd) headers. Can anyone offer a solution? Thanks for any help!


Example:


01/01 01/02 01/03 ..... 12/31 | period total | YTD
adam | sum | sum
brad | sum | sum
carl | sum | sum

[AB33]

Try Pivot Table