Google Spreadsheet Post #1307
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 25, 2013
user Paul Winn (http://productforums.google.com/forum/?zx=lhbkt93evv10#!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.
Thanks
----------------------------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 25, 2013
user Paul Winn (http://productforums.google.com/forum/?zx=lhbkt93evv10#!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.
Thanks
----------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment