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?????
Help Article Resources
Check out the Formula Handbook template!