Hi all,
I'm looking for a formula to find the number of days within a date range, but only for a specific month (in this case, July):
<tbody>
</tbody>
In this instance I'm only looking for the number of days in July, but this will change and I would like to easily change the formula to suit other months.
Thanks in advance.
I'm looking for a formula to find the number of days within a date range, but only for a specific month (in this case, July):
Start Date | End Date | Expected Result (days) |
28/06/2019 | 27/08/2019 | 31 |
15/07/2019 | 15/10/2019 | 17 |
01/03/2019 | 10/07/2019 | 10 |
<tbody>
</tbody>
In this instance I'm only looking for the number of days in July, but this will change and I would like to easily change the formula to suit other months.
Thanks in advance.