+ Reply to Thread
Results 1 to 2 of 2

Auto-Updating Excel Calendar With To-Do List

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    365 Pro Plus

    Question Auto-Updating Excel Calendar With To-Do List


    So I recently started a new job and one of my first tasks is to create an auto-updating calendar in Excel to help plan the rest of our year. I',m not the best with Excel which is why I am reaching out for assistance.

    Basically I just need assistance with finding the best way to create a calendar of the full year and have a list that coincides with it which you can add tasks/dates to, which will then automatically populate the corresponding cells on the calendar.

    I've attached an example template that I found through Microsoft and made a dummy list of tasks that I would need to populate the actual calendar on their specified dates.

    In the end the idea would be to conditional format/color code certain things that are related to each other so that the presentation of the calendar is easy to digest.

    I appreciate any help and assistance with this!

    Please let me know if you need any clarification, etc.
    Attached Files Attached Files
    Last edited by jk2391; 04-06-2020 at 09:20 AM. Reason: adding tags

  2. #2
    Forum Guru
    Join Date
    MS-Off Ver
    Excel 2010/2019

    Re: Auto-Updating Excel Calendar With To-Do List

    Hello jk2391 and Welcome to Excel Forum.
    Although there are some contributors that are expert in the area of calendars, I am not one.
    That said, here is a link to a ready made 'to do' Excel calendar that might meet your needs.
    I hope this will be of some help.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Auto Updating Calendar with Info from Data Tab
    By RBK2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-28-2018, 03:00 PM
  2. Extremely Dynamic Auto Updating Calendar
    By Eprovencio in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-24-2018, 01:28 PM
  3. Formula for auto updating calendar
    By jriemann in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-28-2017, 03:15 PM
  4. [SOLVED] Excel Auto Updating Calendar in Monthly view
    By Ayemzie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2017, 12:40 AM
  5. Auto populate events to excel calendar from a list
    By lridley2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2016, 05:22 PM
  6. Auto-Updating Calendar for Plant Growth
    By vhdblood in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-12-2014, 05:10 PM
  7. Auto Updating Calendar
    By briangutan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2012, 07:16 AM

Tags for this Thread


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