Ask Your Question
0

Auto Formatting Sheet based on date [closed]

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

soop gravatar image

updated 2013-02-12 01:37:17 +0100

qubit gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 05:43:34.207042

Comments

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

qubit gravatar imagequbit ( 2013-01-20 21:41:23 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

m.a.riosv gravatar image

Take a look to this extension, maybe can help:

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

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 186 times

Last updated: Mar 01 '12