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.
Bookmarks