+ Reply to Thread
Results 1 to 5 of 5

File search between two dates

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office XP to Office 2016
    Posts
    1,697

    File search between two dates

    Hi,

    I want to search files with the bellow criteria

    Question is how should I tell windows to find the files that were modified from today to seven days back

    tags:Completed type:xlsm datemodified:Last seven days
    Teach me Excel VBA

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    4,696

    Re: File search between two dates

    Have you tried datemodified:Last week
    Rory
    Yea though I walk through the valley of the shadow of death, at least it's a change of scenery

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office XP to Office 2016
    Posts
    1,697

    Re: File search between two dates

    Thanks rorya for the review, just wait I am gona test it.Please

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office XP to Office 2016
    Posts
    1,697

    Re: File search between two dates

    Hi rory. "Last Week" is skipping today's modified it showed from 10th Sep to 16th Sep, while I need to include today's modified files as well.


    It is to search files which were modified between today's date and today's date - 7 "

  5. #5
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office XP to Office 2016
    Posts
    1,697

    Re: File search between two dates

    I mean last 7 days including today

+ 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. Replies: 6
    Last Post: 07-18-2017, 04:51 PM
  2. Search Folder + Search Excel File and Sum
    By Vanda_a in forum Excel General
    Replies: 1
    Last Post: 03-06-2015, 12:00 PM
  3. Replies: 1
    Last Post: 12-17-2014, 08:14 PM
  4. Replies: 0
    Last Post: 04-21-2014, 04:03 PM
  5. Excel Dates copied from CSV file dont show as Dates
    By vew32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2013, 09:30 AM
  6. [SOLVED] Search for dates whilst ignoring earlier dates for servicing
    By Ju1cy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-10-2013, 11:05 AM
  7. [SOLVED] Button to search and filter all dates between two dates
    By DannyJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2012, 11:12 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