SharonR ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


Can why does this formula above give out different numbers when the start and end date (automated by column) are the same. 


=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?????



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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? 

  • SharonR
    SharonR ✭✭✭✭✭

    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?


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!