+ Reply to Thread
Results 1 to 7 of 7

Finding a specific date

  1. #1
    Forum Contributor
    Join Date
    05-28-2016
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    119

    Finding a specific date

    I have a spreadsheet with dates in a row. I am able to create a macro to highlight the colum of todays date but would also like to create a macro to select a date i enter in a specific cell.
    I have used the folrmula below which is a slight variation on the one that finds todays date and works well.

    My dates are in row 2
    FindDate is the name have given cell A2 where I enter the date I am searching for. This is simply Date in the macro that finds todays date.

    Thanks in advance.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Finding a specific date

    e.g., if I understood correctly:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-28-2016
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    119

    Re: Finding a specific date

    This only highlights the column the "FindDate" is in. Not the column further along the row that I am attempting to find

  4. #4
    Forum Contributor
    Join Date
    05-28-2016
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    119

    Re: Finding a specific date

    Your Range("FindDate") helped me figure it out. I replaced FindDate with it and it worked.
    Thx

  5. #5
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Finding a specific date

    You can shorten it a bit (code of macro), e.g.:
    Please Login or Register  to view this content.
    or use the 'Find' function.
    Last edited by mjr veverka; 01-03-2018 at 07:49 PM.

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Finding a specific date

    dates are notoriously tricky to deal with in VBA
    especially to aussies

    change below line to the format you have the date set in Row 2
    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  7. #7
    Forum Contributor
    Join Date
    05-28-2016
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    119

    Re: Finding a specific date

    Thanks everyone, its working now.

+ 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] Finding overlapping date periods for specific variables
    By pickaside in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2019, 10:00 AM
  2. LOOKUP value by finding specific date
    By domgilberto in forum Excel General
    Replies: 5
    Last Post: 02-12-2016, 06:24 AM
  3. [SOLVED] Finding Highest value in a column between specific date range
    By orshims in forum Excel General
    Replies: 15
    Last Post: 01-21-2015, 03:21 PM
  4. Replies: 3
    Last Post: 05-16-2014, 01:23 AM
  5. Lookup a date in a column and finding specific text value row and clear
    By kx1bn7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2014, 08:27 AM
  6. [SOLVED] Help with finding a specific day/date ten weeks away
    By yeahyeahyeah in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2012, 06:12 PM
  7. Finding a date in a specific column surounded by other columns with similar dates
    By Freakazoid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2012, 05:28 AM

Tags for this Thread

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