+ Reply to Thread
Results 1 to 6 of 6

Show recuurence event in calendar (month view)

  1. #1
    Registered User
    Join Date
    11-25-2012
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    24

    Show recuurence event in calendar (month view)

    Hi experts,

    would like to ask for your favour to create a calendar showing recurrence event in monthly basis. i've created the template but i don't know how i can change the formula in tab "Calendar" to show the recurrence.

    for example,
    Sports - swimming class, i want to show the same item in every Sat in Calendar until 12/31/2018

    School - Quiz, i want to show the same item in 17th of every month util 12/31/2018
    Attached Files Attached Files

  2. #2
    Forum Contributor shivya's Avatar
    Join Date
    08-19-2017
    Location
    Delhi, India
    MS-Off Ver
    2013
    Posts
    240

    Re: Show recuurence event in calendar (month view)

    Quote Originally Posted by teireii View Post
    Hi experts,

    for example,
    Sports - swimming class, i want to show the same item in every Sat in Calendar until 12/31/2018

    School - Quiz, i want to show the same item in 17th of every month util 12/31/2018
    How would user know, what are you looking for?
    To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
    Don't forget to Mention your desired result in the sheet..
    There should be sample data only, a lot of data creates confusion.

    Thanks & Regards

    Shivya

    http://excelvbatipsforbeginners.blogspot.in/

  3. #3
    Registered User
    Join Date
    11-25-2012
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Show recuurence event in calendar (month view)

    user to key in their scheduled activity in Tasklist tabsheet,
    and pops up in calendar tabsheet.
    the frequency also show in calendar tabsheet just like the recurrence activity in outlook.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Show recuurence event in calendar (month view)

    See the attached as a "model":

    It is likely you will have to convert your "Tasklist" into the format of the "Activities" list in the attached. You can then use a similar formula to allocate events to dates.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-25-2012
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Show recuurence event in calendar (month view)

    Thanks,John. however, i'm looking for solution to show the recurrent activities in calendar view. which means there'll be repeat items showing when user click "Daily/weekly/Monthly/ Quarterly"..

    if you look into my example file, i've got the activities showing intially, what i'm missing is the "repeat" activities.

    e.g; swimming class, it should have 4 times showing on Nov, each SAT from 11/4/2017
    Last edited by teireii; 11-06-2017 at 10:10 PM.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Show recuurence event in calendar (month view)

    Using your Tasklist you are going to need a very complex IF (and if at all possible) formula is each cell to cater for all conditions. You have to loop through the Tasklist : you will need VBA to achieve your desired result

    The file I posted has a relatively simple formula: all that is required is to expand your Tasklist to a separate Activities list and then use the same formula.

    You also need to define terms:

    Monthly: same day of month each month (irrespective of day on which this falls)? i.e 21st Jan , 21st Feb or every 28 days ?

    Quarterly: same as above
    Last edited by JohnTopley; 11-07-2017 at 10:01 AM.

+ 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. Outlook 2016 calendar - modified month view
    By digitalcyclist in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2015, 08:40 AM
  2. Can I create a dropdown that will show a 2-month calendar?
    By Vecchia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. Can I create a dropdown that will show a 2-month calendar?
    By Vecchia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. Can I create a dropdown that will show a 2-month calendar?
    By Vecchia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. Can I create a dropdown that will show a 2-month calendar?
    By Vecchia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] Can I create a dropdown that will show a 2-month calendar?
    By Vecchia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  7. Can I create a dropdown that will show a 2-month calendar?
    By Vecchia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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