+ Reply to Thread
Results 1 to 5 of 5

Date function

  1. #1
    Registered User
    Join Date
    09-24-2019
    Location
    Doha , Qatar
    MS-Off Ver
    2016
    Posts
    2

    Date function

    Hi everyone,

    I'm a sports coach and am using this table to keep track of all my athletes development.

    Issue:

    I'm only able to do this for one season at a time.
    (example: for season 2019/2020 the 1st week starts on 25/08/2019)

    In order to be able to compare data from different seasons :

    - How can i include on this file a function that will recognize a different season ?
    (example: for season 2018/2019 the 1st week starts on 02/09/2018)
    Last edited by Alvaro Monteiro; 09-24-2019 at 04:09 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,760

    Re: Date function

    Two files, lots of stuff and not much explanation.

    What do you expect to see? Where do you expect to see it?
    Glenn



  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,954

    Re: Date function

    I'm looking at your file, and I read your question, but I don't understand what it is you want to do in your file. You have a column with the season, and a column with dates. But I don't understand what kind of result you are looking for.



    In order to be able to compare data from different seasons :

    - How can i include on this file a function that will recognize a different season ?
    How do you want to compare data? What do you mean by "recognize" a different season?
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  4. #4
    Registered User
    Join Date
    09-24-2019
    Location
    Doha , Qatar
    MS-Off Ver
    2016
    Posts
    2

    Re: Date function

    Thanks for your replies

    Sending a example of what i want to see in the ACTIVITIES GRAPH separator.

    I'd like to put together the info i have from seasons 2017/2018 , 2018/2019 and 2019/2020 in one file and , in this way , compare directly the number of lessons the boys had in the first 5 weeks of ALL seasons

    My problem is the starting week. As you can see in the LISTES separator , i can only put one date.

    I'm also sending my attempt to build 1 file with all 3 seasons.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Alvaro Monteiro; 09-25-2019 at 08:33 AM.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,906

    Re: Date function

    If I understand correctly then the pivot table/chart in the attached copy of the file is what you want.
    The chart is a clustered column and another slicer has been added for season.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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