Results 1 to 10 of 10

Thread: $15 To Amend Macro To Find The Next Available Earlier Or Previous Date

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi

    Thanks.

    Please find attached file. Let me know if you have any concern.
    Attached Files Attached Files
    Last edited by Admin; 04-23-2014 at 07:45 AM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  2. #2
    Junior Member
    Join Date
    Jan 2014
    Posts
    9
    Rep Power
    0
    Quote Originally Posted by Admin View Post
    Hi

    Thanks.

    Please find attached file. Let me know if you have any concern.
    Hi,

    Thanks for uploading this, however it doesn't seem to work as it should.

    As a test I endered 21/01/2014 as the date, however it is picking up 06/09/2012 from sheet Q even though there are many enties after this.

    Thanks

    After further tests it seems to return the same date for sheet Q no matter what you enter.
    Last edited by pedros23; 04-23-2014 at 12:46 PM.

Similar Threads

  1. Find the value of the due date falls between two dates
    By mahmoud-lee in forum Excel Help
    Replies: 2
    Last Post: 03-14-2014, 10:48 AM
  2. Replies: 7
    Last Post: 03-11-2014, 05:38 PM
  3. Macro stops running if date is not in past...
    By Carlos Arruda in forum Excel Help
    Replies: 4
    Last Post: 03-10-2013, 04:33 PM
  4. How to Lock or Unlock row basis previous cell input?
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 2
    Last Post: 07-25-2012, 02:40 PM
  5. Find Quarter Month From Date In Excel
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 15
    Last Post: 04-19-2012, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •