Formula Help


I need to calculate the NETWORKDAYS in a sheet but also need to make the formula use todays date if the cell is blank. This is the formula that I have now but it is counting weekends and holidays in the calculation and I need it to omit weekends and holidays.

=IF(ISBLANK([Booked Date]1), TODAY() - [*Received Date]1, [Booked Date]1 - [*Received Date]1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!