Can I control what is displayed in a FileDialog

Unfortunately, the FileDialog object in Excel doesn’t have a built-in way to filter files by date directly — it can only filter by file type or name patterns using the .Filters property. If you want to limit the files shown to those modified within a certain date range (like from 7 days ago until yesterday), you’d need to handle that part yourself after the user selects a folder or files. A common approach is to let the user pick a folder, then use VBA code to loop through the files in that folder (using Dir or the FileSystemObject) and check each file’s DateLastModified property. You can then build a custom list or display a message box showing only the files that fit your date criteria. In short, the FileDialog can’t filter by date before showing files, but you can easily apply your own date filter afterward in code.

------------------------------------
Don't forget to mark as solution if my answer suits you