+ Reply to Thread
Results 1 to 2 of 2

Filter yesterday onwards

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Filter yesterday onwards

    Hi all, I have a data set that I want to automate daily, I need to filter (show) only content from yesterday onwards. Dates are in Column A.

    I have the code below, but this seems to filter in American date format - for instance if I run it today, I see data from 11th December onwards rather than 12th November.

    Please Login or Register  to view this content.
    The column is stored as UK date format data


    Can anyone assist

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Filter yesterday onwards

    Maybe your time zone is set to American instead of UK?

    The Date function will return your PC date
    Cheers!
    Deep Dave

+ 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] Extract 5th string onwards but exclude 6th string onwards if found a specificlist of words
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-07-2016, 03:48 AM
  2. [SOLVED] Hide Columns IF Row 2 onwards is Blank
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-01-2015, 04:45 PM
  3. [SOLVED] Hide columns if empty from Row 3 onwards vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2014, 03:41 AM
  4. [SOLVED] VBA code to select today() onwards from filter
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2014, 06:39 AM
  5. [SOLVED] Yesterday Date Filter
    By Angelfish13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2013, 03:08 PM
  6. Sum values from a certain date onwards
    By manny_cb in forum Excel General
    Replies: 3
    Last Post: 08-13-2010, 02:19 AM
  7. Sorting from row A6 onwards
    By teebird in forum Excel General
    Replies: 2
    Last Post: 05-18-2007, 02:46 AM

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