Results 1 to 2 of 2

Looking up dates in a column with a formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2014
    Location
    Laurel, Mississippi
    MS-Off Ver
    Excell 2010
    Posts
    2

    Looking up dates in a column with a formula

    I'm very new to Excel and VBA. With that said, I'm trying to do an IF THEN statement where:

            Dim ExpDate = Date +30
            If Cells(i,6) < ExpDate Then
    And the rest of the code will copy a different cell (without the date) on the active sheet onto another sheet.

    I've been able to get this to do exactly what I want it to do when searching up a numerical value that resulted from a formula:
           If Cells(i,13)<0 Then
    but it's not working for the dates.

    Also, (and I don't know if this makes a difference) IF THEN with the dates is the second IF THEN in my FOR NEXT.

    I don't know if VBA is comparing the formula with the ExpDate or if it's reading the acutal date and comparing it to ExpDate.

    Can someone please help a VBA rookie find out where I'm going wrong?

    Any help would be GREATLY appreciated!!!
    Last edited by JBeaucaire; 09-20-2014 at 02:25 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-08-2014, 03:50 PM
  2. [SOLVED] have a column of random dates. want a formula for an output column of them sorted
    By James C in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2013, 04:24 PM
  3. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  4. Formula help for counting,with a column of dates and a column of n
    By Altstatten in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-08-2005, 05:35 PM
  5. Replies: 0
    Last Post: 02-04-2005, 03:58 PM

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