Formulas
NETWORKDAY/S
Can why does this formula above give out different numbers when the start and end date (automated by column) are the same.
Eg...
=NETWORKDAYS(Date created, Date modified) = no of days
Date created column = 01 august 2019 (tues), Date modified column = 01 August 2019 (tues) = 1
On the next line it will say
Date created column = 01 august 2019 (tues), Date modified column = 02 August 2019 (tues) = 1
Why are this formula still reading 1 on the second line???
Does Am and PM get taken into consideration in this formula?????
Comments
-
There are several potential factors that are accounted for in this equation. The first is that Smartsheets displays Local Time, but in the backend they calculate based on the server's local time or some kind of GMT time. There will be occasions where I am displaying the local time but its calculating on 3 hours earlier or later. Try downloading your sheet in excell. It usually converts the dates there to the server times. Let me know what you find?
-
It does work, but downloading the data would defeat the purpose of having this data in Smartsheets. This data feeds multiple projects across our office. If it can not calculate the time correctly our statistics will be out across all our sheets.
Is common for all Network/Networking/Networkingdays formulas?
-
I agree with you wholeheartedly. Its doesn't make any sense and can be a bear when factoring dates. I happen to know that more focused time stamps are coming soon. Hopefully in the last quarter.
Help Article Resources
Categories
Check out the Formula Handbook template!
