Can table builder/ NP formula handle functions like DATEDIF and IFS?
For example:
=NP("Formula","=IFS((DATEDIF([@[Posting Date]],TODAY(),""m"")<4),""Current""))")
This did not work but it works in Excel. Not sure if the syntax needs modification or if this is out of scope for the NP function.
Thanks.
Hello Jeff -
Since you only have a single condition you are testing, I would recommend using the Excel IF() function, rather than the less-supported IFS() function.
Then, your function would look like this:
=NP("Formula","=IF(DATEDIF([@[Posting Date]],TODAY(),""m"")<4,""Current"")")
This should work in any version of Excel.