+ Reply to Thread
Results 1 to 2 of 2

List the Current Date Range?

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    List the Current Date Range?

    I have a huge dashboard that has several pivot charts, slicers etc. The slicers I have are Week number and Month. To set this up I actually have a date column in my data, but also a week number column which I have the week number using WEEKNUM.

    So when looking at the slicer for weeks it just has weeks 1 - 53 which the end user doesn't necessarily know which dates those are for. I didn't wan the slicers to actually have the date range on them because it is sloppy (although I may have to go that route)

    But I was wonder if when I click say Week 1 if I could then have a cell that shows the "currently viewable date range" so like when I click Week 1 it would say "01/01/2021 - 01/02/2021" (since week one is just those two days)

    Any ideas?

    I've gone back and forth on this stupid thing. First I didn't have a weeknum column but was just using date grouping but it caused other issues with getting weekly data and monthly data so I went this route.

    I guess I could just rename the week numbers to date ranges but then my slicer is just sloppery to look at.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: List the Current Date Range?

    Perhaps create a date range field in your database and insert it as a slicer?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with Calculating date range over 7 years from current date
    By nr6281 in forum Excel Formulas & Functions
    Replies: 38
    Last Post: 08-13-2019, 01:37 AM
  2. Highlight Rows Based on Date Range Using Static Date and Current Date
    By SaraStravers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2015, 07:38 PM
  3. [SOLVED] Selecting data from a date range based on the current date
    By ian-sheridan in forum Excel General
    Replies: 12
    Last Post: 06-20-2013, 11:38 AM
  4. Formula that will pull by a date range of the current date
    By terra_hewitt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2012, 11:08 AM
  5. generating date range from current date
    By dexelguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2008, 04:52 PM
  6. [SOLVED] How do I get the most current date from a list of dates?
    By GenaM in forum Excel General
    Replies: 4
    Last Post: 07-18-2006, 10:30 AM
  7. How do I enter a date range ie -7 from current date in MS QUERY
    By notsmartenough in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 06:25 PM

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