+ Reply to Thread
Results 1 to 4 of 4

Adjusting an If statement for a date current or older

  1. 06-23-2020, 01:32 PM #1
    nickpavlov
    nickpavlov is offline
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    405

    Adjusting an If statement for a date current or older

    I am looking to alter the following formula.

    But I need it to be if H13 is 0 and also B13 is the current date or older, then show a blank cell.

    =IF(H13=0,"",VLOOKUP(H13,$W$14:$X$20,2,TRUE))

    I appreciate any help figuring out this addition to the formula.

    Thanks,
    Nick
    Reply With QuoteRegister To Reply
  2. 06-23-2020, 02:23 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Adjusting an If statement for a date current or older

    maybe this?
    =IF(and(H13=0,b13<=today()),"",VLOOKUP(H13,$W$14:$X$20,2,TRUE))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 06-23-2020, 02:37 PM #3
    nickpavlov
    nickpavlov is offline
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    405

    Re: Adjusting an If statement for a date current or older

    Thank you!
    Reply With QuoteRegister To Reply
  4. 06-23-2020, 02:38 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Adjusting an If statement for a date current or older

    Happy to help and thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change code so macro activates when entry date is older or equal to current date
    By Big.Moe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2017, 10:59 PM
  2. [SOLVED] Help Adjusting Current Formula!
    By jnswbc in forum Excel General
    Replies: 1
    Last Post: 02-02-2016, 10:56 AM
  3. Using an IF statement to record current date and then have that date NOT change
    By rpeck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2015, 03:19 PM
  4. Adjusting array arguments; editing current code
    By BDarden in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2014, 02:02 PM
  5. [SOLVED] I want any date 90 days or older from current date change color
    By Big Abalone in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2006, 12:10 AM
  6. Deleting rows older than current date and inserting a new row
    By Dan E. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2005, 11:20 AM
  7. Converting Older Dates to the Current Year
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 12:00 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1