Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Open Office Calc question: do date ranges actually exist?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="sid777" data-source="post: 787847" data-attributes="member: 81949"><p>I am at a loss as to how to perform a (seemingly) simple function in OpenOffice Calc.</p><p>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.</p><p></p><p>For example:</p><p></p><p>Column A has descending days of the week listed:</p><p>Sun = cell A1</p><p>Mon = cell A2</p><p>Tues = cell A3</p><p>Wed = cell A4</p><p>Thurs = cell A5</p><p>Fri = cell A6</p><p>Sat = cell A7</p><p>(etc...)</p><p></p><p>Column B has descending dates for the whole year:</p><p>01/01/09 = cell B1</p><p>01/02/09 = cell B2</p><p>01/03/09 = cell B3</p><p>01/04/09 = cell B4</p><p>01/05/09 = cell B5</p><p>01/06/09 = cell B6</p><p>01/07/09 = cell B7</p><p>01/08/09 = cell B8</p><p>(etc...)</p><p></p><p>In Column C, I would like to have every 7th (seventh) cell hold the date range for the previous 7 cells in Column B:</p><p>01/01/09 - 01/07/09 = cell C7</p><p></p><p></p><p>......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 <strong>entire</strong> year and for each year to come. There's GOT TO be a simple way to set this up as a function, right?</p><p></p><p>--Sid</p><p><a href="mailto:sid@blacklionaudio.com">sid@blacklionaudio.com</a></p></blockquote><p></p>
[QUOTE="sid777, post: 787847, member: 81949"] 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 (etc...) 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 (etc...) 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 [B]entire[/B] year and for each year to come. There's GOT TO be a simple way to set this up as a function, right? --Sid [email]sid@blacklionaudio.com[/email] [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Open Office Calc question: do date ranges actually exist?
Top