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     www.energyefficientbuild.com.   Mar-10-2016

post by: holymak:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/3kODC4dA0ws;context-place=forum/docs
Weekly Calendar.

Mon 7/3/16

Tue 8/3/16

Wed 9/3/16

Thur 10/03/16

Fri 11/03/16

Sat 12/3/16

Sun 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/16

Tue 15/3/16

Wed 16/3/16

Thur 17/03/16

Fri 18/03/16

Sat 19/3/16

Sun 20/03/16

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

Any advice would be gratefully welcomed.

Thanks

------------------------------------------------------------------------------------------------------------------------------------