How can I calculate the average NETDAYS between 2 columns?

dcoletta

dcoletta ✭

04/04/23 in Formulas and Functions

I want to calculate the average NETDAYS between these two columns as a field in my sheet summary. How can I accomplish this?

Tags:

0 ·

Answers

Austin Smith ✭✭✭✭✭

04/04/23

@dcoletta
I believe you'd have to have a third column with =Netdays([start date], [end date]) as a column formula, and just take an average of that.

1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Index/Collect while meeting specific criteria and doing math
Good afternoon community, I'm in need of help with a formula that I feel has come close, but still just off of the mark. I have three sheets: The first is holding static data (Inventory Cost sheet). The second sheet (Tool Inventory) is where data comes into the sheet from a form and some math formulas do calculations based…
Issue with Highlighting Columns that have different values
I have a sheet where I am tracking values from one month to the next (values imported using DataShuttle). I want to highlight the columns where the values are different, using a helper column: =IF(Bananas@row = [Previous Bananas]@row, 1, 0) However, I am having the formulas return 0s when the formulas are NOT DIFFERENT.…
Net Days between a previous day and today.
I have the following columns Comments Date of Last Attendance Weeks Not Submitted Under "Comments", you might see something like "Last Attendance Day: 11/01/2024." I used =RIGHT(Comments@row, 10) to get the Date of Last Attendance. I need to determine how many days it has been since that date using today's date, and divide…