Skip to Content
0

On SAP Lumira, i need to calculate the Days between 2 dates but exclude weekends. How do i do so??

Jan 10 at 05:45 PM

74

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

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.

0
Former Member

Hi, My data source is an Excel extract of over a million records from ITSM.

0

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 09 at 06:06 AM
0

Thats what i ended up doing. Thanks.

Share
10 |10000 characters needed characters left characters exceeded