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 2007 - Start Date and End Date question

Discussion in 'All Other Software' started by jmstampe, Feb 17, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. jmstampe

    jmstampe Thread Starter

    Joined:
    Feb 17, 2012
    Messages:
    8
    So I have this excel spreadsheet and an example of it basically looks like this:


    Project Phase Person Capacity Start Date End Date
    A Design 1 25% 1/15 3/16
    A Model 1 25% 3/17 5/11
    A Design 2 25% 1/15 3/16
    A Model 2 25% 3/17 5/11



    I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

    Dates
    Person Jan Feb Mar Apr May
    1 25% 25% 25% 25% 25%
    2 25% 25% 25%

    Is this even possible, either in a pivot table, or even using formulas?
     
  2. pip22

    pip22

    Joined:
    Nov 21, 2004
    Messages:
    2,536
  3. jmstampe

    jmstampe Thread Starter

    Joined:
    Feb 17, 2012
    Messages:
    8
    Thanks, I'll move that over there.
     
  4. dvk01

    dvk01 Moderator Malware Specialist

    Joined:
    Dec 14, 2002
    Messages:
    56,236
    First Name:
    Derek
    closed duplicate
    please continue in your other topic http://forums.techguy.org/business-applications/1041709-excel-2007-start-date-end.html

    for the future please don't start a new topic when somebody suggest a different forum is more appropriate. Report the post & ask for it to be moved
    http://www.techguy.org/rules.html
     
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...
Similar Threads - Excel 2007 Start
  1. Kalpana2407
    Replies:
    1
    Views:
    173
  2. gars45
    Replies:
    0
    Views:
    125
Thread Status:
Not open for further replies.

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

  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