nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

How do I create a formula to calculate the number of days between two dates, excluding weekends?

jhon Antonio

I'm trying to calculate the number of working days between two date columns in Smartsheet, but I want to exclude weekends from the count. Is there a specific formula or workaround that I can use to achieve this?

Find more posts tagged with

Comments

Nic Larsen

You'll want to use this function in your formula:

NETWORKDAYS Function | Smartsheet Learning Center

Sign in to join the conversation!

Quick Links

Trending discussions

Cross-Sheet Formula Help
I have two sheets: the first sheet is called 'Source Sheet', and the second is called 'Helper Sheet'. I want to use the Helper Sheet to track survey responses that are fed into the Source Sheet. The formula should reference a column in the first sheet named 'Company Email'. If that column is not blank on the Source Sheet,…
How to pull the title from a hierarchy at ancestor level 0
Hi All, I just want to pull the title 'BSR Tracker' in column 33 Please note there's another Blue bar in the same tracker i.e. two levels at ancestor = 0 so i just want to pull that title in. currently the formula im using but doesn't seem to be working is: =IF(COUNT(ANCESTORS([Site Name]@row)) = 0, "",…
Issue with Email Notifications via Workflow Automation
Dear Smart Community, I am experiencing an issue with a specific email ID that is not receiving notifications triggered through workflow automation. However, the user is able to receive emails when I send an update request manually. I have tested several scenarios in coordination with the IT team. For example, when…