Formula for counting days
Hi! I use the below forumla to count days between to columns that have dates. The issue is it is counting the as individual days which basicall adds a day to the count. I want a true count. Help?
Dtes calculated 6/7/24 to 6/8/24 (to me this is one day) the formula gives me 2
=NETDAYS([Created Date]@row, [Date Backup Sent Back]@row)
Best Answer

Since you are using NETDAYS are you looking to eliminate weekends? If you just want to calculate the number of days between two dates, regardless of holidays or weekends, try this:
The Difference Formula is:
=([Date2]@row  [Date1]@row)If you are always going to subtract the earlier date from the later date, this will return a positive number of days. If it's the opposite, like, Date1  Date2, then multiply by 1 at the end to get a positive number, like this:
=([Date2]@row  [Date1]@row) * 1
If I am not understanding your question, or what you are trying to achieve, please let me know.
Best!
Answers

Since you are using NETDAYS are you looking to eliminate weekends? If you just want to calculate the number of days between two dates, regardless of holidays or weekends, try this:
The Difference Formula is:
=([Date2]@row  [Date1]@row)If you are always going to subtract the earlier date from the later date, this will return a positive number of days. If it's the opposite, like, Date1  Date2, then multiply by 1 at the end to get a positive number, like this:
=([Date2]@row  [Date1]@row) * 1
If I am not understanding your question, or what you are trying to achieve, please let me know.
Best!

I would just subtract one day from the end result:
=NETDAYS([Created Date]@row, [Date Backup Sent Back]@row)  1
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!