Results 1 to 9 of 9

Excel 2007 : Shifting cells based on data from a cell whose position varies.

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2009
    Location
    Cedar Bluff, VA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Shifting cells based on data from a cell whose position varies.

    Hello Everyone,
    First I must admit it... I am a newbie. What little I know was taught to me by my old boss. What I'm trying to do is create a yearly Bible reading program using Excel 2007. The starting date will vary from year to year (C1). I simply added one to each of the other cells so their dates would change as well
    (=C1+1). The part I can't solve has to do with one particular daily passage that I always want to fall on the Sunday that is 50 days from the Saturday that occurs between days 15 and 21. Is there a formula that will place the particular passage correctly and shift the other cells so that there are no voids before or after and no data overlaps in cells? I don't know if this is possible, but thanks to anyone who has a thought!! I have attached the spreadsheet although I haven't typed it to the problem passage because once I realized the shortcomings of my simple C1+ formula I stopped typing in case I wanted the impossible.
    Attached Files Attached Files
    Last edited by yllek; 11-06-2009 at 09:45 AM. Reason: Typo in title

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1