New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

Start a Discussion

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Open Office Calc question: do date ranges actually exist?

Post Reply New Thread Subscribe

Thread Tools

Member Since: Jan 14, 2009
Posts: 1
sid777 is on a distinguished road

sid777 is offline
I am at a loss as to how to perform a (seemingly) simple function in OpenOffice Calc.
I have a column containing sequential dates through the year, and in the next column, in every seven cells, I would like to have a date range of the previous week listed. Does this make sense? (I've written & rewritten & rewritten AGAIN this question, and it still seems confusing.

For example:

Column A has descending days of the week listed:
Sun = cell A1
Mon = cell A2
Tues = cell A3
Wed = cell A4
Thurs = cell A5
Fri = cell A6
Sat = cell A7

Column B has descending dates for the whole year:
01/01/09 = cell B1
01/02/09 = cell B2
01/03/09 = cell B3
01/04/09 = cell B4
01/05/09 = cell B5
01/06/09 = cell B6
01/07/09 = cell B7
01/08/09 = cell B8

In Column C, I would like to have every 7th (seventh) cell hold the date range for the previous 7 cells in Column B:
01/01/09 - 01/07/09 = cell C7

......I hope this makes SOME KIND of sense, since I am dumbfounded on how this can be accomplished without typing out the all of the date ranges as text throughout the entire year and for each year to come. There's GOT TO be a simple way to set this up as a function, right?

QUOTE Thanks

Member Since: Jan 09, 2009
Location: Chicago Burbs
Posts: 28
RamblinMan is on a distinguished road
Mac Specs: MB 2.4 Aluminum, iBook G4, PowerBook G4, iMac G5

RamblinMan is offline
The only catch is that you need to convert the date into a text value before concatenation.

Sample formula for column C7:
=CONCATENATE(TEXT(B1;"dd-mmm-yyyy");" - ";TEXT(B7;"dd-mmm-yyyy"))

Then, use any method you want (copy/paste, fill, etc.) to place the formula in every seventh cell going down. NOTE: I just did this on a Windows machine, so no confirmation on a Mac.

MB Alum 2.4/2/250; VirtualBox with Vista and Ubuntu
iMac G5, iPods (4th Gen Nano, iPod Mini)
QUOTE Thanks

Post Reply New Thread Subscribe

« Alternative to toast? | iphoto gone! »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Starter
Last Post
Who's On My Network? macbookjimbo Internet, Networking, and Wireless 28 01-07-2011 11:57 AM
Open Office 3.0; MacBook OSX; Auto-Play .pps files web OS X - Apps and Games 0 12-09-2008 07:34 PM
Microsoft Office vs. Open Office UncSki1218 Switcher Hangout 17 10-26-2008 04:40 PM
Weird Mac Microsoft Office question sara.gallegos OS X - Apps and Games 1 08-12-2008 11:14 AM
Question about open office CaptainStandish Switcher Hangout 3 02-22-2004 12:25 AM

All times are GMT -4. The time now is 06:41 PM.

Powered by vBulletin
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.

Welcome to

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!

(4 digit year)

Already a member?