How to Compute a Date Difference in an IF statement

< Back to Search results

 Category: [Excel]  Demo Available 

How to Compute a Date Difference 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.



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


Obtained from the OzGrid Help Forum.

Written by royUK.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

How to use Formula: =IF ERROR
How to COUNTIF using input cell as range depth
How to combine more that one IF AND formula
How to use IF formula with multiple criteria
How to use IFERROR - example provided


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.



stars (0 Reviews)