Results 1 to 5 of 5

Thread: IF AND function with a DATE calculation

  1. #1
    Board Regular
    Join Date
    Jul 2019
    Posts
    177
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default IF AND function with a DATE calculation

    Hello,

    I am hoping someone could help me clean up a formula of mine.

    I am looking to have the formula calculate between the current date and date received and then if this result is greater than 5 AND another cell ="0" return a "true" result, other wise "false".

    This is the formula I wrote but I am missing something....

    =if(and((DATEDIF(TODAY(), G2, "d")>5),H2="0","true","false")

    I hope someone can help me with this.

    Thank you

    Carla

  2. #2
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,258
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: IF AND function with a DATE calculation

    Try:

    GHIJ
    1Date Rec.
    29/23/20190 FALSE
    39/12/2019 TRUE
    48/30/2019 TRUE
    59/20/2019 FALSE

    Spreadsheet Formulas
    CellFormula
    J2=IF(AND(TODAY()-G2>5,$H$2=0),"TRUE","FALSE")


    Excel tables to the web >> Excel Jeanie HTML 4

  3. #3
    Board Regular
    Join Date
    Jul 2019
    Posts
    177
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF AND function with a DATE calculation

    This formula did not work.
    A date appeared in column H. Since it was not "0" it should have returned a FALSE however it returned "TRUE".

    Both conditions have to be met to return a true, a date greater than 5 and H = 0 (aka no date).

    am I missing something?

    Thank you

    Carla

  4. #4
    Board Regular
    Join Date
    Jul 2019
    Posts
    177
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF AND function with a DATE calculation

    I figured it out. was referencing H2 only.

    Thank you for all of your help!!!!

    Last edited by willow1985; Sep 24th, 2019 at 04:03 PM.

  5. #5
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,258
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: IF AND function with a DATE calculation

    You're welcome. Thanks for the feedback.

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
  •