Thursday, March 10, 2016

yogi_Create Weekly Calendar In Cells B1:H1 For Current WeekK From Monday To Sunday Dates In dd mm yyyy

Google Spreadsheet   Post  #2050
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-10-2016
post by: holymak:!topic/docs/3kODC4dA0ws;context-place=forum/docs
Weekly Calendar.
Mon 7/3/16Tue 8/3/16Wed 9/3/16Thur 10/03/16Fri 11/03/16Sat 12/3/16Sun 13/03/16

I would like to set up a weekly calendar as above for revision timetable for my son.

I would like for it to update each week so that next week will autoupdate to:

Mon 14/3/16Tue 15/3/16Wed 16/3/16Thur 17/03/16Fri 18/03/16Sat 19/3/16Sun 20/03/16

It would help a lot if the current date cell is highlighted as shown.

Any advice would be gratefully welcomed.