User Profile
Koong
Copper Contributor
Joined Sep 24, 2021
User Widgets
Recent Discussions
Re: How to calculate the duration in days excluding weekends between 2 date by using formula
Hi, i trying add plus 1, formula working well. =IF(AND(WEEKDAY([End Date])>1, WEEKDAY([End Date])<7), IF(AND(WEEKDAY([Start Date])>1, WEEKDAY([Start Date])<7), DATEDIF([Start Date], [End Date], "D") - (INT(DATEDIF([Start Date], [End Date], "D") / 7) * 2), DATEDIF([Start Date], [End Date], "D") - (INT(DATEDIF([Start Date], [End Date], "D") / 7) * 2) - 1), DATEDIF([Start Date], [End Date], "D") - (INT(DATEDIF([Start Date], [End Date], "D") / 7) * 2) - 2) +1How to calculate the duration in days excluding weekends between 2 date by using formula
Hi, Please help me how to calculate the duration day excluding weekend, I try to using formula like as bellow, but it's not working: "=IF(AND(WEEKDAY([End Date])>1, WEEKDAY([End Date])<7), IF(AND(WEEKDAY([Start Date])>1, WEEKDAY([Start Date])<7), DATEDIF([Start Date], [End Date], "D") - (INT(DATEDIF([Start Date], [End Date], "D") / 7) * 2), DATEDIF([Start Date], [End Date], "D") - (INT(DATEDIF([Start Date], [End Date], "D") / 7) * 2) - 1), DATEDIF([Start Date], [End Date], "D") - (INT(DATEDIF([Start Date], [End Date], "D") / 7) * 2) - 2)" Thanks,SolvedHow to disable all template microsoft Lists on mobile app(IOS/ANDROID)
Dear experts, Im already disable all template Ms Lists on Web by using command on Sharepoint Powershell. I guest on mobile will be same web, but it not same. all template still showing up on mobile app. So please let me know how to disable them on mobile app. Thanks!489Views1like0CommentsPrevent session as used Rds Trial 120 day on VM Windows Server 2012 R2
i have to checked daysleft. It show 43 day. It's only support 2 session. I also try check everything is i know, Try reset RDS, Restart NIC, ... But it's not working. I have purchased LC RDP per user Cal 2019 on MS . But can not add LC. It show pop-up invalid LC I do not know how to fix it. Please help me! Thank you so much!825Views0likes1Comment
Recent Blog Articles
No content to show