Nov 03 2022 06:55 AM
I am attempting to a duration calculation in SharePoint Lists, but it seems to be off by a day. I know there is an underlying Time Zone issue with the NOW formula, but for some reason it is also off by an entire day for me as well.
Excel Formula
=IF(A2<>"",TEXT(A2-NOW(),"d"),"")
Where A2 = 11/8/22 and NOW = 11/3/22
Outcome = 4
SharePoint Lists Formula
=IF([Due Date]<>"",TEXT([Due Date]-NOW(),"d"),"")
Where [Due Date] = 11/8/22 and NOW = 11/3/22
Outcome = 3
Is there some sort of setting in SharePoint Lists that would cause this discrepancy? I thought it might taking off weekends when I originally set a date for next week, but it seems to just be one day off no matter what date I set.