Basic NETDAYS Help!

LDenton

Disclaimer: I'm a SmartSheet beginner, and only at an amateur level with Excel formulas.

I've reviewed quite a few NETDAYS posts on here already and tried variations of the solutions in all, but so far every NETDAYS variation I've tried has returned the #UNPARSEABLE error.

I'm trying to write a formula that will calculate the # of days from "Date Submitted" column to "Date Closed" column, and if the "Date Closed" cell is blank, to calculate to Today's Date instead.

=NETDAYS([Date Submitted]@row, [Date Closed]@row)

=IFERROR(NETDAYS([Date Submitted]@row, IF(ISDATE([Date Closed]@row, [Date Closed]@row, TODAY())), 0)

Does anyone have suggestions for how to modify the formula to get rid of the #UNPARSEABLE errors?

Thank you so much in advance!

Samuel Mueller

@LDenton okay, looks like you just have some parenthesis in the wrong place. Try this

=IFERROR(NETDAYS([Date Submitted]@row, IF(ISDATE([Date Closed]@row), [Date Closed]@row, TODAY())), 0)

also keep in mind that the today formula will only work if you open and save the sheet. Refer to this help article if you need it to update every day without opening the sheet.

Automatically update the TODAY function in formulas | Smartsheet Learning Center

Samuel Mueller

@LDenton "Data submitted" is actually a date column right? Kind of looks like your primary column.

LDenton

https://community.smartsheet.com/discussion/comment/358046#Comment_358046

Hi Samuel!

Yes, "Date Submitted" is a date-formatted column. My primary column for this sheet is separate.

Samuel Mueller

@LDenton okay, looks like you just have some parenthesis in the wrong place. Try this

=IFERROR(NETDAYS([Date Submitted]@row, IF(ISDATE([Date Closed]@row), [Date Closed]@row, TODAY())), 0)

also keep in mind that the today formula will only work if you open and save the sheet. Refer to this help article if you need it to update every day without opening the sheet.

Automatically update the TODAY function in formulas | Smartsheet Learning Center

LDenton

Thank you so much Samuel, your suggestion worked like a charm! I really appreciate your help!

Samuel Mueller

Happy to help!