on 01-10-2018 5:45 PM
On SAP Lumira, i need to calculate the Days between 2dates but exclude weekends. How do i do so??
i am able to calculate the days but it includes the weekends and Holidays
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What is your data source? If it is BEx it may be easier to calculate the business days there, as it can read the SAP Factory calendar.
Hi, My data source is an Excel extract of over a million records from ITSM.
I would use the Workday function in Excel, and then bring it into Lumira
See https://support.office.com/en-us/article/WORKDAY-function-f764a5b7-05fc-4494-9486-60d494efbf33
Thats what i ended up doing. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.