Formula Help

Angela Bearden

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)

Mike Wilday

Try this:

=IF(ISBLANK([Booked Date]@row), NETWORKDAYS([*Recieved Date]@row, Today()), Networkdays([*Recieved Date]@row, [Booked Date]@row))

You can add specific holiday dates based on the instructions here:

https://help.smartsheet.com/function/networkdays

Angela Bearden

That worked! Thank you for your help!

Mike Wilday

Awesome. Glad I could help you out!