Forum Discussion
JoMoWasHere
Sep 05, 2023Copper Contributor
Long IF formula to addon if more than 24 months, then TRUE is "Aged"
Hi, Currently working on an excel formula to eventually put up on SharePoint. Unfortunately, SharePoint only provides me with 1 line for an excel formula and I'm trying to automate, in a sense, a...
SergeiBaklan
Sep 06, 2023Diamond Contributor
I'm sorry to jump in, but why DATEDIF(TODAY(), E4,"Y"), not DATEDIF( E4,TODAY(),"Y") ? Earlier date shall be first here.
mathetes
Sep 06, 2023Gold Contributor
I'm sorry to jump in, but...
No need to apologize, Sergei. Your comments and insights are always valuable. Always.
I hadn't gotten to that level of detail yet; was trying first to address the IF vs IFS issue, along with clarity of the conditions and responses.