+ Reply to Thread
Results 1 to 2 of 2

Auto populating a calendar for homework tracking

  1. #1
    Registered User
    Join Date
    02-21-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    1

    Auto populating a calendar for homework tracking

    Hi!

    I am in need of anyone's help. I am currently working on a homework tracker. In it, I've created a tab which consists of a list of days and the different tasks assigned per subject. I've allotted 5 cells per subject per day as there are instances where there are more than 1 task for a given subject. However, I now want to create a calendar view of these tasks. What formula should I use so that the Calendar contains a list of the task assigned? Please see as attached:

    track hw.xlsx

    Any help is appreciated.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Auto populating a calendar for homework tracking

    Gave it a try. See attachment.
    Did take the liberty to change the structure of the list to make it better searchable for the calendar formula.
    The formula may look pretty complex (not to say horrible), but it works and is actually simpler than it looks at first glance.
    I'm explaining the formula in the sheet FormulaExplained.
    Just see if this could work for you.
    Attached Files Attached Files
    Last edited by Tsjallie; 03-27-2015 at 10:03 AM.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto Populating Calendar
    By slesensky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-18-2014, 09:57 PM
  2. Auto-Populating Excel Calendar
    By excel_help1 in forum Excel General
    Replies: 1
    Last Post: 08-23-2013, 09:39 PM
  3. Replies: 0
    Last Post: 02-21-2013, 09:04 AM
  4. Questions about auto populating calendar
    By Corocotan in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-18-2012, 02:47 PM
  5. Auto-Populating Excel Calendar
    By Vbort44 in forum Excel General
    Replies: 27
    Last Post: 11-16-2011, 03:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1