+ Reply to Thread
Results 1 to 6 of 6

Help Modifying a Formula

  1. #1
    Registered User
    Join Date
    01-09-2017
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    4

    Question Help Modifying a Formula

    I downloaded the student assignment calendar from the microsoft site (https://templates.office.com/en-us/S...ner-TM03458077).

    I want to modify it so instead of "Assignment Due" appearing on the calendar, the information written in the description of the Assignment tab is displayed on the calendar. For example If I write:
    - "History Test" in B4 and 1/10/2017 in C4 of the Assignments Tab, "History Test" will display on the calendar on the Month View and the Week View tab when I'm displaying January.
    - "Science Test" in B5 and 1/10/2017 in C5 of the Assignments Tab, "Science Test" will display on the calendar on the Month View and the Week View tab when I'm displaying January.
    - "Science Homework" in B6 and 1/13/2017 in C4 of the Assignments Tab, "Science Homework" will display on the calendar on the Month View and the Week View tab when I'm displaying January.

    I hope this makes sense.

    Thank you in advance,
    Joslyn
    Attached Files Attached Files
    Last edited by Joslyn; 01-09-2017 at 04:14 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help Modifying a Formula

    Hi,

    Please clarify what you expect. I for one don't understand.
    I don't see an Assignments tab and not entirely sure what YOU mean by calendar.

    Manually add the results you expect and tell us which sheets/ranges are original data and which are the results.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-09-2017
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    4

    Re: Help Modifying a Formula

    I want the info entered into the assignments tab to show up as written on the calendar for the date listed.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Help Modifying a Formula

    In A6 of Month tabs

    =IF(WEEKDAY(DATEVALUE("1-"&MoMonth&" - "&MoYear),1)=COLUMN(A$2),1,IF(LEN(A6)>0,A6+1,""))

    Copy across to column H

    in B7 in a month tab

    =IF(LEN(B6)=0,"",IFERROR(INDEX(Assignments[DESCRIPTION],MATCH(DATE(MoYear,MoMonthNum,B6),Assignments[DUE DATE],0)),""))

    Copy and paste to other dates

    NOTE: You changed "Assignment" tab to events which I have changed back

    If you require it to be "EVENTS" then simply rename.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-09-2017
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    4

    Re: Help Modifying a Formula

    Thank you!!!!

  6. #6
    Registered User
    Join Date
    01-09-2017
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    4

    Re: Help Modifying a Formula

    Is there a way so that multiple events can be displayed on the same date on the calendar?

+ 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. Modifying A Formula
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  2. [SOLVED] Modifying A Formula
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. Modifying A Formula
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  4. [SOLVED] Modifying A Formula
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Modifying A Formula
    By Mangesh Yadav in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 07:05 AM
  6. Modifying A Formula
    By Mangesh Yadav in forum Excel Formulas & Functions
    Replies: 36
    Last Post: 09-06-2005, 04:05 AM
  7. Modifying A Formula
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  8. [SOLVED] Modifying A Formula
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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