I have creating leave management application I am facing one issue with weekends
I have below column
If I put in the start date as Friday (Weeknum 1) and end date as Monday (Weeknum 2), it calculates 4 days of leave and 4 duration column is showing
What i need is , I need to show only two fields to enter the duration
How to get this ? Any suggestion ?
Verwende Workday()
I used but i did not get the expected result @Tommy62
If I put in the start date as Friday (Weeknum 1) and end date as Monday (Weeknum 2), it calculates 4 days of leave and 4 duration column is showing
What i need is , I need to show only two fields to enter the duration
Es ist viel einfacher zu erreichen, wenn Sie NETWORKDAYS() in der Backend-Tabelle verwenden. Siehe diesen Thread: Werktage zwischen 2 Terminen
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |