Net days

Michael Figone

Michael Figone ✭✭

02/06/20 in Formulas and Functions

I have 2 date fields. I want to total net days between the 2 dates in a 3rd field. How do I do this? Thanks.

0 ·

Answers

Michael Figone ✭✭

02/06/20

More accurately, columns, not fields.

0 · Share on Facebook Share on Twitter
Chris Mondeau Community Champion

02/06/20 edited 02/06/20

Hi Michael,
There are a few functions you can use to calculate the number of days between dates, but here's one for netdays:

Netdays: https://help.smartsheet.com/function/netdays
Networkday: https://help.smartsheet.com/function/networkday
Networkdays: https://help.smartsheet.com/function/networkdays

0 · 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

Concatenate formula to combine Date and Time into unique code
When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. How can get the Concatenate formula to just reproduce the Date format…
How to fix adding 1 or -1 to date difference calculations
Hello, I'm trying to set up a formula which will calculate the difference between two dates to achieve a days overdue number for our orders. Current formula is: =IF(Status@row = "Delivered", NETWORKDAYS([Delivery Date Expected]@row, [Delivered Date]@row)) This is returning an almost correct result, except it always adds a…
Calculating KM Distance between Lat and Long
Good morning. I have tried the 2 formula's that I found on the internet and copilot and neither are working for me. Can someone please help me figure out how to calculate the KM distance between the lat longs?