+ Reply to Thread
Results 1 to 2 of 2

I want to create an automatic calendar, if is it posible witout using vba

  1. #1
    Registered User
    Join Date
    08-24-2017
    Location
    Quito, Ecuador
    MS-Off Ver
    2010
    Posts
    1

    I want to create an automatic calendar, if is it posible witout using vba

    I have a list of 35 people who need to take a test periodically, some of them every 2 month, some every 3 month, some every 6 months, it depends, I want to create a calendar, where in the column E is January, in column F is February, in column G is March, etc.

    In the row 2 are the dates of the first person: E2 = date 1(February 2017), F2 = date 2(April 2017), G2 = date 3(June 2017), etc.

    I want to put those dates in the respective column for example date 2 should be in the column F which is February, date 3 should be in column H which is April and so on...

    if it is possible I do not want to use vba and/or macros.

    Thank you for your time

    FYI: I upload the excel workbook I am working on, the working sheet is sheet 2
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,288

    Re: I want to create an automatic calendar, if is it posible witout using vba

    Try it like this, attached.
    Attached Files Attached Files
    Last edited by Bernie Deitrick; 08-24-2017 at 11:44 AM.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Create automatic calendar
    By joeljoel in forum Excel General
    Replies: 5
    Last Post: 03-05-2014, 11:39 PM
  2. [SOLVED] Help me fix attached code (create Outlook email then create calendar item)
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2013, 08:15 PM
  3. How do I close a workbook witout saving changes
    By plunkettyplunk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2010, 05:24 AM
  4. [SOLVED] Automatic Calendar in excel
    By Tony in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-17-2005, 03:05 PM
  5. [SOLVED] Automatic Calendar
    By Trudy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-02-2005, 04:37 PM
  6. Min witout counting #DIV/0!
    By carloslp in forum Excel General
    Replies: 1
    Last Post: 03-29-2005, 12:40 PM
  7. [SOLVED] Calendar that is automatic
    By choejerry in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 09:06 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