asked 2012-02-29 17:02:24 +0200

soop
1 ● 1

5693 ● 3 ● 48 ● 41

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

delete close flag offensive retag edit

Comments

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

qubit ( 2013-01-20 21:41:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-03-01 01:32:12 +0200

mariosv

4659 ● 20 ● 46

Take a look to this extension, maybe can help:

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

link delete flag offensive edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

1 follower

Stats

Asked: 2012-02-29 17:02:24 +0200

Seen: 106 times

Last updated: Mar 01 '12

Auto Formatting Sheet based on date