Finding a date in a column
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Finding a date in a column
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular steve case's Avatar
    Join Date
    Apr 2002
    Posts
    787
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Hello board - finding a date in a column

    Leap years and holidays probably complicate this issue, but going forward, aren't the last financial days of the month well known for the United States or for any other country (they have different holidays) as well?

    Well maybe not that well known here's a web page: Monthly Closing Calendar that says for next June it's "TBD"

    Here's the wikpedia page on the topic:
    https://en.wikipedia.org/wiki/Accounting_period

    The question/issue is two fold, generating the calendar of monthly closing dates (the hard part*)
    and then looking up that date.

    * If different organizations are involved it could get ugly.
    AKA StACase

  2. #12
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    10,996
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Hello board - finding a date in a column

    EOMONTH takes account of bank holidays and WORKDAY has another parameter you can add for a range of holiday dates.

    The VBA for the Find is relatively straightforward (when you are on a PC and not a phone as I am at the moment anyway )
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #13
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    10,996
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Hello board - finding a date in a column

    Bad typing, it should have read...
    EOMONTH takes account of Leap Years and WORKDAY has another parameter you can add for a range of holiday dates.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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