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.