+ Reply to Thread
Results 1 to 2 of 2

Filtering Dates Problem

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    2

    Filtering Dates Problem

    I have a report coming from a payroll software program with dates in it. When the report comes out, all the dates are shown in the filter as a single date, there is no option to filter them by year and month. There was a way to transform the date data so, that the filter shows them by year and month. What was the way? I have done this and I can't remember now. If somebody can help, I will be grateful. Thank you.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: Filtering Dates Problem

    There should be an option Date Filters... which allows you to filter by various date periods.

    If that doesn't appear then the dates might no actually be 'real' dates.

    You can test for that by putting this formula in an empty cell and replacing A2 with a reference to one of the dates.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If it returns FALSE then it's not a 'real' date.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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