Results 1 to 2 of 2

Thread: Searching a method to store date range

  1. #1
    Neophyte user0X's Avatar
    Join Date
    May 2018
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Searching a method to store date range



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

    I have a table with the column headings ‘From Date’, ‘To Date’ and ‘Amount’ besides several others.

    I’m looking for a way to get this date range (‘From Date’, ‘To Date’) to show up in the pivot table as rows.

    As I crude workaround I have created a column that Concatenates these two cells.

    Would appreciate if anyone can throw light on the best way to achieve this. Also if there is a better practice to store date ranges.


    Sent from my iPhone using Tapatalk

  2. #2
    Acolyte alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    62
    Articles
    0
    Excel Version
    2019
    It would be very helpful if you uploaded to this site a sample workbook showing a before and after scenario. Make sure that there is enough data to represent your actual data file.

Posting Permissions

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