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 |
---|---|
16 | |
10 | |
9 | |
8 | |
3 |