Results 1 to 3 of 3

Thread: Help with Pulling in List to copy Dates

  1. #1
    Neophyte Urkas's Avatar
    Join Date
    Sep 2019
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2010

    Help with Pulling in List to copy Dates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a set number of dates that I need to forecast. Some of the months I have dont always have a Forecast but I want to be able to at least post a 0 still in that date.

    What I need is to be able to use a list of parts IE

    301080.01
    301081.01
    301082.01
    301083.01

    Etc ( this parts will be somewhat all over the place as part as how they may look )

    And from there I want to have them formatted as follows.

    And just have this repeat through all the parts I have listed.

    Ideally I would want to be able to set my Range at the top of this Excel sheet

    IE two cells - Start and End Date

    Item Date
    301080.01 9/1/2019
    301080.01 10/6/2019
    301080.01 11/3/2019
    301080.01 12/1/2019
    301080.01 1/5/2020
    301080.01 2/2/2020
    301080.01 3/1/2020
    301080.01 4/5/2020
    301080.01 5/3/2020
    301080.01 6/7/2020
    301080.01 7/5/2020
    Attached Files Attached Files

  2. #2
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    29
    Articles
    0
    Excel Version
    2016
    in worksheet "Report"
    C2=min(b:b)
    D2=max(b:b)

    ???

  3. #3
    Neophyte Urkas's Avatar
    Join Date
    Sep 2019
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2010
    Quote Originally Posted by caabyyc View Post
    in worksheet "Report"
    C2=min(b:b)
    D2=max(b:b)

    ???
    No that does not work

    : /

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •