1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel - Expanding Inclusive Dates

Discussion in 'Business Applications' started by djgassman, Nov 19, 2011.

Thread Status:
Not open for further replies.
  1. djgassman

    djgassman Thread Starter

    Joined:
    Mar 25, 2009
    Messages:
    15
    Hi,I hope there is a relatively easy solution to an issue I've tried to resolve and am completely stumped!!! The information I'm working relates to airline arrivals and departures.I get a simple spreadsheet on a monthly basis (I've attached an abbreviated copy) that tells me:Flight 123 will arrive at xx:xx time and depart at yy:yy time on dd/mm/yyFlight 234 will arrive at xx:xx time and depart at yy:yy time on dd/mm/yyetc.The problem I'm having is the format of the arrival and departure information: it currently is listed in the columns as "Effect" for the first date it will occur that month, and "Discon" for the last date it will occur that month. (ie: Flight 123 will start arriving on 4/02/11 and do so daily until 4/17/11.What I'm trying to do is manipulate the spreadsheet so it will display the info for the inclusive dates in between....ie: Flt 123 also comes in on 4/03/11, 4/04/11, etc. If it could do that, I could then do a simple pivot table based on the dates and arrival/departure times. (the second page of my attached sheet is the pivot table I've got so far).My goal with the pivot table is to reflect simply each day of the upcoming month, and to reflect the total flights arriving between 0700-0759hrs that day, between 0800-0859hrs that day, etc. Is this something someone could review and give me some guidance? I'm not very proficient at Excel yet, but I'm learning! Thank You,Dave(Also... if what I've described is possible, there will be another issue to deal with: the Column "Frequency" reports whether these flights are "daily", or limited to certain days of the week. (For instance "x7" means it does not operate on Sundays, "135" means it operates only Mon, Wed, and Fri. "Daily" of course means 7-days a week.)
     
  2. djgassman

    djgassman Thread Starter

    Joined:
    Mar 25, 2009
    Messages:
    15
    Regarding my earlier post, this is an abbreviated version of the original spreadsheet (with a pivot table)...
    Thanks again for any guidance or assistance!! Dave
     

    Attached Files:

  3. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,408
    First Name:
    Wayne
    i have merged your thread - you need to reply to this thread in order to post any updates and NOT start a new thread
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1027506

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice