I am having a hard time wrapping my head around the error here and I hope someone can help me out.</SPAN></SPAN>
I am trying to calculate how many days until an employee’s annual performance report is due, and display it in days. The formula works great for the overdues, but those that are not overdue are showing up as “#NUM!”. The first question (the easy one) is how can I replace the “#NUM!” with “0”? The date of the last evaluation close out date is in Column C</SPAN></SPAN>
=IF(C2<=TODAY()<=0,0,DATEDIF(C2,TODAY(),"d"))</SPAN></SPAN>
The second, and harder question, is how can I make a nested IF to do one of 3 actions:</SPAN></SPAN>
If the due date is past, display “-## (Past Due)</SPAN></SPAN>
If the due date is within 30 days, display “## (Coming Due)”</SPAN></SPAN>
If the due date is more than 30 days, display “##”</SPAN></SPAN>
Thanks in advance</SPAN></SPAN>
-Huey</SPAN></SPAN>
I am trying to calculate how many days until an employee’s annual performance report is due, and display it in days. The formula works great for the overdues, but those that are not overdue are showing up as “#NUM!”. The first question (the easy one) is how can I replace the “#NUM!” with “0”? The date of the last evaluation close out date is in Column C</SPAN></SPAN>
=IF(C2<=TODAY()<=0,0,DATEDIF(C2,TODAY(),"d"))</SPAN></SPAN>
The second, and harder question, is how can I make a nested IF to do one of 3 actions:</SPAN></SPAN>
If the due date is past, display “-## (Past Due)</SPAN></SPAN>
If the due date is within 30 days, display “## (Coming Due)”</SPAN></SPAN>
If the due date is more than 30 days, display “##”</SPAN></SPAN>
Thanks in advance</SPAN></SPAN>
-Huey</SPAN></SPAN>