Thursday, July 25, 2013

yogi_Set Up A Calendar For List Of Days Of Specified Day of The Week In Months Of A Year

                                          Google Spreadsheet   Post  #1307
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul 25, 2013
user Paul Winn (!category-topic/docs/spreadsheets/m0xWUgZ6sVM)
Specific dates for all Sundays in a month
I have a simple church schedule workbook with sheets for every month.  The 3 column headings are Date, Sound, Video.  Under the last 2 columns there will be just names of people assigned for either sound or video.  Since church is on every Sunday in a month, I would like to calculate the specific dates of the the 4 or 5 Sundays (and place them in 4 or 5 cells/rows beneath the "date" heading) for the corresponding month an year.  Maybe it is easier to just look at a calendar and copy the values but if there is a better way I'd love to know.