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
Check out the Formula Handbook template!