Computing DateDif in an If statement

  • How to determine if the date shown is before January 1 of current year in an If formula to determine whether arrears are payable. I need to know if the date difference is more than the days between Today() and January 1, 2019


    where if (datedif is more than today minus January 1, 2019, 0,arrears payable. I can use multiple columns to work this out but I am asking if there is a concise formula for this task, please.


    =if(datedif(D3,-today()<days to start of year,0,"Arrears to pay") where D3 = January 1, 2019.

  • Hello,


    What about :


    Code
    1. =IF(TODAY()<D3,"Arrears to Pay","")


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Glad your problem got fixed ... :wink:


    Thanks for your Thanks ..AND for the Like ...:smile:


    :cheers:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)