# Basic NETDAYS Help!

Options
✭✭

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!

• Overachievers
Options

@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

• Overachievers
Options

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

• ✭✭
Options

Hi Samuel!

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

• Overachievers
Options

@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

• ✭✭
Options

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

• Overachievers
Options

Happy to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!