+ Reply to Thread
Results 1 to 4 of 4

populating a calendar w/product names on their due dates from dates on seperate tab

  1. #1
    Registered User
    Join Date
    01-18-2016
    Location
    California, USA
    MS-Off Ver
    WINDOWS 7
    Posts
    30

    populating a calendar w/product names on their due dates from dates on seperate tab

    Hello Beautiful People,

    I'm wondering if there's a way to have a product name, which is currently recorded in a column showing the date it goes out and the date it's due back..... to have those names populate onto a calendar on a separate tab?
    For example, as the order comes in, it is recorded on the next line with the product name, date out and date due, but my problem is the due dates arent necessarily in chronological order, so it's hard for me to easily see whats due next. I'm hoping that a formula, when a date is populated in column D, it will automatically populate onto the next tab, in the correct cell of the calendar for the date. Does that make sense?
    I've included a sample of what I'm needing. Thanks for any help!!
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,899

    Re: populating a calendar w/product names on their due dates from dates on seperate tab

    Here's one option:

    G3 =IFERROR(INDEX($B:$B,MATCH(DATE(2018,3,G2),$D:$D,0)),"")

    Drag through M3 and then copy and paste G3:M3 to rows 5, 7, 9, and 11.

    Note that this only returns the first match.

    You mentioned that there could be more than one match.
    Excel isn't very fond of putting multiple results into the same cell and I would not recommend trying to do so.
    Is there a maximum number of product names with the same due date?

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,899

    Re: populating a calendar w/product names on their due dates from dates on seperate tab

    I formatted your data into a table, included 3 rows per day, and used a formula to pull multiple matches.

    G3 =IFERROR(INDEX($B:$B,SMALL(IF(DAY(Table1[DATE DUE])=G$2,ROW(Table1[DATE DUE])),ROWS($1:1))),"") Ctrl Shift Enter

    Drag the formula through M3 then down through row 5.

    Repeat for rows 7 through 9, 11 through 13, etc.

    See attachment.
    Attached Files Attached Files

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,899

    Re: populating a calendar w/product names on their due dates from dates on seperate tab

    Thanks for the rep and for marking this thread as SOLVED.

+ 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. Populating list of dates from another sheet with Start Dates and End Dates
    By Jesshloly in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2015, 04:07 AM
  2. Dates and Names to Calendar
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2015, 01:17 AM
  3. Auto Populating Calendar for Multiple Dates from Column Data
    By TrackingDates in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-18-2014, 03:39 PM
  4. Auto-populating a calendar with multiple dates
    By lamct in forum Excel General
    Replies: 2
    Last Post: 07-20-2013, 05:16 PM
  5. Replies: 0
    Last Post: 02-21-2013, 09:04 AM
  6. How to seperate dates into calendar-year quarters?
    By Coachwooten in forum Excel General
    Replies: 2
    Last Post: 04-25-2012, 10:21 AM
  7. [SOLVED] POPULATING DATES IN A CALENDAR
    By markstro in forum Excel General
    Replies: 0
    Last Post: 08-15-2006, 07:00 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