H2 is a date field (ex. 01/13/2017)
AN2 is a date field (ex. 01/12/2017)
Here is my formula:
=IF(H2="","-1",IF(AN2="","-1",DATEDIF(AN2,H2,"D")))
In the example above, my forumula is returning a value of '1' but my formula below is returning a value of #NUM! in situations where H2 is an older date than AN.
Ex.
H27 = 12/08/2016 and AN27 = 01/11/2017 returns a #NUM!
H28 = 01/03/2017 and AN28 = 01/06/2017 returns a #NUM!
I would like to fix this by modifying my formula to say if the difference in dates is either GE or LE 99, set the value to -1.
How would I modify my existing formula to accomplish that?
Bookmarks