Auto Formatting Sheet based on date

I’m trying to figure out how I can have a workbook change the dates (numbers) in specific cells on sheets based on a month selected from a drop down list. Each sheet is 1 week, so on the 1st and last sheets there might only be 2 or 3 days vs a full 7

I’m assuming I’d need a master Calendar sheet to reference? Any help is appreciated

Hi @Soop, Did @mariosv’s answer work for you? If so, please mark it as ‘correct’. Thanks.

Take a look to this extension, maybe can help:

http://extensions.services.openoffice.org/en/project/RiessDateBrowser