+ Reply to Thread
Results 1 to 2 of 2

Create calendar on basis of table with items without dates but with deadlines

  1. #1
    Registered User
    Join Date
    08-19-2019
    Location
    rotterdam
    MS-Off Ver
    10
    Posts
    1

    Create calendar on basis of table with items without dates but with deadlines

    Hi
    I would like to create a calendar with dates on the basis of a table of say 30 items, each with a specific deadline, for example: 10 days before quarter end, or: each month end.
    I can make calendars when items dates are known, but I want to create a calendar for months/years to go forward, based on the static table.
    Any suggestions?
    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,485

    Re: Create calendar on basis of table with items without dates but with deadlines

    It would help if you attached a sample Excel workbook, showing what data you have and how you would like it to look (compile this part manually).

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Don't try to use the Paperclip icon, as it doesn't work on this forum.

    Hope this helps.

    Pete

+ 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] Populate items across calendar based on base dates
    By NicBKK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2018, 10:41 PM
  2. Create a table/pivot table using different items items from a column
    By stevetton in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-28-2016, 10:30 PM
  3. Conditional formatting for dates approaching deadlines
    By mommyof3Teens in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2016, 10:55 AM
  4. Connecting a calendar with appointments and deadlines to excel
    By Excel3210 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-24-2016, 09:07 AM
  5. Interactive Calendar for managing deadlines
    By V.Cell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2016, 07:58 AM
  6. Replies: 3
    Last Post: 07-29-2014, 01:20 PM
  7. How do I create work day only calendar dates?
    By rjmckay in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-23-2011, 05:44 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