Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

click to hide/show revision 2
retagged

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