Forum Discussion
Issue with IF multiple formula with 3 outcomes
Albaman83 Avoid using DATEDIF() for this. It's not an official Excel function and only exists "to support older workbooks from Lotus 1-2-3. Furthermore, The DATEDIF function may calculate incorrect results under certain scenarios". (Source: MS support page in the DATEDIF function).
DATEDIF expects a start date in the first element and an end date in the second. If the first element is greater than the second you get !NUM#.
Use standard operators in stead. Like:
=IF(date < TODAY(), "Expired", date - TODAY()& " days remaining.")Once it has passed the first test you know that warranty has not expired yet and you can safely calculate the days remaining by calculating date - TODAY()
Albaman83 Avoid using DATEDIF() for this. It's not an official Excel function and only exists "to support older workbooks from Lotus 1-2-3. Furthermore, The DATEDIF function may calculate incorrect results under certain scenarios". (Source: MS support page in the DATEDIF function).
DATEDIF expects a start date in the first element and an end date in the second. If the first element is greater than the second you get !NUM#.
Use standard operators in stead. Like:
=IF(date < TODAY(), "Expired", date - TODAY()& " days remaining.")
Once it has passed the first test you know that warranty has not expired yet and you can safely calculate the days remaining by calculating date - TODAY()
Riny_van_Eekelen Thank you for the reply. You are awesome. It worked perfectly.
Albaman83 Great!