hi, I want to develop a sheet like this:
The table has a start date and end date ( Aug 18 to Dec-19).
The reference date is any date between these two dates, I want to get the number of service days in each month starting from the reference date to the expiry data (23-Aug-18 has an expiry date 22-aug-2019)
Can anyone help me with a formula to break days like this ?
The table has a start date and end date ( Aug 18 to Dec-19).
The reference date is any date between these two dates, I want to get the number of service days in each month starting from the reference date to the expiry data (23-Aug-18 has an expiry date 22-aug-2019)
Can anyone help me with a formula to break days like this ?