How to Compute a Date Difference in an IF statement
Requirement:
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.
Solution:
Code:
=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.
Gallery
