Experts...I have a data which has start date and end date in 2 columns.. i need to derive completed days in a month based on start and end date .
Start Date | End date | 31-Jan-23 | 28-Feb-23 | 31-Mar-23 | 30-Apr-23 | 31-May-23 | 30-Jun-23 | 31-Jul-23 | 31-Aug-23 | 30-Sep-23 | 31-Oct-23 | 30-Nov-23 | 31-Dec-23 |
01-Jan-23 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | |
01-Jan-23 | 15-Sep-23 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 15 | - | - | - |
10-Apr-23 | 15-Sep-23 | - | - | - | 22 | 31 | 30 | 31 | 31 | 15 | - | - | - |