Formula Help

shoey24

Hello, I have a formula to determine the days between two cells:

=IF(OR([Status]@row = "CLOSED", ISDATE([Closure Date]@row) = 1), [Closure Date]@row - [Date Initiated]@row, TODAY() - [Date Initiated]@row)

However, I need to add in to return "N/A" to the days open if the value within Date Initiated is N/A. I have a similar formula working in Excel which if I could replicate would be excellent.

=IFERROR(IF(OR(ISNUMBER(SEARCH("review",N2)),ISBLANK(N2),ISNUMBER(SEARCH("TBD",N2))), DAYS(TODAY(),[@[Date Initiated]]),[@[Closure Date]]-[@[Date Initiated]]),"N/A")

Essentially the goal is to calculate how long a document has been opened, and once closed will appropriately just take the difference between open and closed columns. Adding in that if the document was not needed (indicated by N/A), then the output for days open would be N/A. If needed I can post a simple version of what this looks like from Excel currently.

Matt Johnson

Hi @shoey24

Will this formula work?

=IF(Status@row = "Open", "", IF(Status@row = "N/A", "N/A", IF(Status@row = "Closed", [Closure Date]@row - [Date Initiated]@row, "")))

Thanks,

Matt