Tuesday, October 3, 2017

yogi_Pull Dates For A Specified Weekday Between Specified Dates

Google Spreadsheet   Post  #2254

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-03-2017
question by: HTMInternational1
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/UiX1LDXqD2k;context-place=forum/docs
Is there a way to format a cell to display mm/dd/yyyy and generate only Sundays in 1yr

I am starting a sermon database, i have them listed by Date(Sunday only), Sermon ID#, Title, and Scripture/Notes. 
I would like to format a cell to just generate all the Sundays in a specific year. Also I would like to repopulate the sheet for the next year in another sheet. I have tried to use the =Day function , and the =Date , as well as the =weekend function but nothing works. is this possible?


No comments:

Post a Comment