Tabs, links or list to select a date or date range buttons

[Kelli*]

Hello,

I would like to insert tabs, links or a list into my spreadsheet to allow a manager to just select a date or date range required i.e. yesterday, last week, last fortnight, MTD or enter a specific date.

Is this possible?

Excel 2010

Thanks in advance!

Kelli

 

[rahulshewale1]

hii @Kelli* ,


Please share your workbook with desire output by manually .


Regard
Rahul shewale

 

[Kelli Webb]

Hi Rahul,

It's a bit difficult to show the desired output, but hopefully the attached provides more clarity.

Please let me know if you require anything further.

Cheers Kelli

 

[Kelli Webb]

Rahul, The Dynamic date in the Table column AF starts in AF7
I went back 6 days and forward to the first week of the next month..
Sorry I forgot to highlight that in the spreadsheet