Hello Guys ,
Please i customized a form in info-path from a list in SharePoint and i need to calculate the difference between two dates using date picker fields excluding Saturdays and Sundays, i have very little idea on how to go about it
Ill totally appreciate any help on this ,
Thanks.
Hello Guys ,
For anyone following the thread
I created two date pickers in SPD named Issued and completed , and then i added a calculated column .. added the formula below to it , set the data type as text only and it worked ,
= ( [Completed] – [Issued] )
– ( ROUNDDOWN( ( [Completed] – [Issued] ) / 7 , 0 ) * 2 )
– ( IF( WEEKDAY( [Issued] ) = 7 , 1 , 0 ) )
– ( IF( WEEKDAY( [Completed] ) = 1 , 1 , 0 ) )
– 1
It calculated the weekdays only and excluded weekends
Thanks
What if: 1. The Issued date is 03/06/2017 (Monday) and the Completed date is 03/10/2017 (Friday)? Shouldn’t the output be 4, but the formula output is 3? 2. The Issued date is 03/06/2017 (Monday) and the Completed date is 03/14/2017 (Tuesday). Shouldn’t the output be 6, but the formula output is 5? Thank you!