+ Reply to Thread
Results 1 to 4 of 4

Get only dates from selected month transposed

  1. #1
    Forum Contributor
    Join Date
    03-14-2005
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    329

    Get only dates from selected month transposed

    Hello.

    I have a worksheet with dates that I am continously adding dates to.
    I'd like to be able to do some charts where only selected dates are included.
    The idea is to add a date to let the function know which month we are searcing for.
    then I'd like the result of the function to write all dates only within the selected month using transpose etc.

    I have attached a workbook where I try to explain how I want the result to be.

    Do anyone know how I can do this?

    /Anders
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Get only dates from selected month transposed

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-14-2005
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    329

    Re: Get only dates from selected month transposed

    Very much thank you! It worked like a charm!!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Get only dates from selected month transposed

    You're welcome & thanks for the feedback.

+ 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] Change Dates in Cells when selected Month in another column.
    By Shahbazk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2020, 03:07 PM
  2. Replies: 7
    Last Post: 01-16-2017, 03:45 AM
  3. [SOLVED] Sum a selected month's data across a range of dates
    By rooboyz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2012, 11:29 PM
  4. Macro to fill dates as per the selected month in the cell A1
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-04-2012, 03:30 AM
  5. Show Saturday Dates when Month selected from DV list
    By scottylad2 in forum Excel General
    Replies: 6
    Last Post: 12-01-2010, 04:35 PM
  6. Replies: 2
    Last Post: 08-28-2008, 06:06 PM
  7. Populate dates by selected month
    By cggamer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2007, 01:03 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