Results 1 to 2 of 2
  1. #1

    Member Since
    Jan 14, 2009
    Unhappy Open Office Calc question: do date ranges actually exist?
    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?


  2. #2

    Member Since
    Jan 09, 2009
    Chicago Burbs
    MB 2.4 Aluminum, iBook G4, PowerBook G4, iMac G5
    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)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open Office Question
    By vank66 in forum Switcher Hangout
    Replies: 3
    Last Post: 06-17-2009, 12:02 PM
  2. Downloaded Open Office but can't find Calc
    By Noels in forum macOS - Apps and Games
    Replies: 9
    Last Post: 03-16-2008, 10:03 PM
  3. open office question
    By domromer in forum Switcher Hangout
    Replies: 5
    Last Post: 10-02-2007, 09:37 PM
  4. Another Software Question: Open Office
    By natoryy in forum macOS - Apps and Games
    Replies: 7
    Last Post: 05-31-2006, 08:04 PM
  5. Question about open office
    By CaptainStandish in forum Switcher Hangout
    Replies: 3
    Last Post: 02-22-2004, 12:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts