A. Smith Posted October 7, 2014 Share Posted October 7, 2014 Like many, I assume, I use a spreadsheet to plan my sermons. As I was putting 2015 together I found myself, once again, wishing there was a way to automatically populate a column (or row) with the dates for each Sunday of the year. I've looked and looked and can't find one. The various formulas I've found (adding 7, etc) don't work month-to month. Any ideas? Any alternatives? How do you write out your plan? Link to comment Share on other sites More sharing options...
Tony Lawrence Posted October 7, 2014 Share Posted October 7, 2014 (edited) Put in the first Sunday of the year and then drag down and select 52 cells. Then go to the EDIT menu, then choose FILL and the SERIES, step value should be set to 7. Viola!, you have the dates for the year. In the second column I put at the top AM Sermon, third column is PM Sermon. Edited October 7, 2014 by Tony Lawrence 1 Link to comment Share on other sites More sharing options...
Abram K-J Posted October 7, 2014 Share Posted October 7, 2014 I just started one of these myself this summer--I do it in Google, so I can just send a view-only link to worship leaders and folks who have other roles in the service... it's been a really convenient way to track everything! Tony--thanks for the tip! I'll see if Google Sheets (or whatever it's called now) can do something similar.... or just do it in Excel and copy-paste it in. Link to comment Share on other sites More sharing options...
Tony Lawrence Posted October 7, 2014 Share Posted October 7, 2014 I just played with Google Sheets (spreadsheets) and you can put in Jan 4, 2015 and then select the next cel below, and type = and click the previous cell and then put +7 and it will give you every Sunday for 2015. 1 Link to comment Share on other sites More sharing options...
Abram K-J Posted October 7, 2014 Share Posted October 7, 2014 Awesome--thanks, Tony! That is how I will set up 2015, then. Link to comment Share on other sites More sharing options...
Alistair Posted October 7, 2014 Share Posted October 7, 2014 Viola? Link to comment Share on other sites More sharing options...
Abram K-J Posted October 7, 2014 Share Posted October 7, 2014 (Strings swell when you do this) 1 Link to comment Share on other sites More sharing options...
ukfraser Posted October 7, 2014 Share Posted October 7, 2014 Don't you start at advent (30th nov)???????? Link to comment Share on other sites More sharing options...
Abram K-J Posted October 7, 2014 Share Posted October 7, 2014 Well, no, I don't start writing 2015 till...2015. Link to comment Share on other sites More sharing options...
Ken Simpson Posted October 7, 2014 Share Posted October 7, 2014 The other really neat way you can do this is in Excel (or Google Sheets) put in the first two dates you want in the column (say 4 Jan 2015 then 11 Jan 2015 then after highlighting both of them, just drag the bottom right corner down as far as you want, and yet another voila! (rather than the miraculous appearance of a mid-sized stringed instrument) 1 Link to comment Share on other sites More sharing options...
Tony Lawrence Posted October 7, 2014 Share Posted October 7, 2014 (edited) I repent in sackcloth and ashes for my typo. Edited October 7, 2014 by Tony Lawrence 2 Link to comment Share on other sites More sharing options...
Ken Simpson Posted October 7, 2014 Share Posted October 7, 2014 Glad you have seen the error of your ways tony, or else I may have had to string you up! (I can hear the mass groans from the other side of the world!) 3 Link to comment Share on other sites More sharing options...
Abram K-J Posted October 8, 2014 Share Posted October 8, 2014 (edited) [deleted] Oops. Wrong thread! Edited October 8, 2014 by Abram K-J Link to comment Share on other sites More sharing options...
A. Smith Posted October 8, 2014 Author Share Posted October 8, 2014 (edited) Wow. That didn't work for me. I was using google sheets. I'd put in 1/4/15 1/11/15 1/18/15 and it would populate 1/19/15 1/20/15, etc. hmm Edit: I figured it out. I wasn't puling the lower right corner of the selection box. Got it. I wish I knew that yesterday!! Edited October 8, 2014 by A. Smith Link to comment Share on other sites More sharing options...
Ken Simpson Posted October 8, 2014 Share Posted October 8, 2014 Glad you got it to work. It’s a nice trick isn’t it. It can be used for any series. Excel is amazing, and Google sheets almost so... Link to comment Share on other sites More sharing options...
A. Smith Posted October 8, 2014 Author Share Posted October 8, 2014 Yeah. I was originally using numbers. It seems to be getting worse with every iteration. You can't even export tab delimited. A train wreck, it seems to me. Don't have excel anymore so Sheets it is . . . Link to comment Share on other sites More sharing options...
Ken Simpson Posted October 8, 2014 Share Posted October 8, 2014 I was very hopeful for Numbers as I think Keynote is fantastic and Pages really quite good, but Numbers always seems to promise but never quite deliver... Excel rulez, Sheets is close. Link to comment Share on other sites More sharing options...
A. Smith Posted October 8, 2014 Author Share Posted October 8, 2014 Yes. I really can't imagine what Apple has in mind with Numbers. it just makes no sense to continually remove useful features. I don't know how they expect to replace Microsoft office. At least, I figure that's the goal. Maybe it's something more subversive, mwahahah. Link to comment Share on other sites More sharing options...
Ken Simpson Posted October 8, 2014 Share Posted October 8, 2014 Link to comment Share on other sites More sharing options...
ukfraser Posted October 9, 2014 Share Posted October 9, 2014 Just concentrating on iOS compatibility?. I switched to office fairly quickly on the mac as pages doesn't have good enough compatibility with word for what I use. Even office 2011 and office 2010 have some differences in formatting the same file. ;o( Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now