any function used in pql to calculate days between the two date column such as in excel networkdays does (consider start date and end date , exclude weekends, ignore timestamps)

Try Remap_TIMSTAMPS, datediff, days_between

The WORKDAYS_BETWEEN function determines the amount of workdays between two given dates. It should work similar to the networkdays function in excel.

syntax - WORKDAYS_BETWEEN ( start_date, end_date, calendar_specification [, calendar_id_column])

The WORKDAYS_BETWEEN function retrieves its information regarding valid workdays from the passed Calendar configuration. For more information on this, see the following link

https://docs.celonis.com/en/workday_calendar.html