Ignore Weekends Date and show the column based on date selection

G_S
Bronze 3
Bronze 3

I have creating leave management application I am facing one issue with weekends 

I have below column

  1. Start Date
  2. End Date
  3. I have 5 column with number field, User will enter duration for each day , Each field will be show based on Start and End date 

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 ?

 

0 3 76
3 REPLIES 3

Verwende Workday() 

G_S
Bronze 3
Bronze 3

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

Top Labels in this Space