Hi all. I'm needing to calculate the number of days employed for the financial year if there is either a start and/or a finish date. But if both are blank, as it is for the employee in Row 7, then I need it to return the value of 365.
Hoping you can help. See below screenshot. Thanks in advance.
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Hoping you can help. See below screenshot. Thanks in advance.
J | K | L | |
---|---|---|---|
1 | |||
2 | |||
3 | Start FY | 01/07/2018 | |
4 | End FY | 01/07/2019 | |
5 | Start Date | Finish Date | No. of days employed this FY |
6 | 01/10/2018 | ||
7 | |||
8 | 31/08/2019 |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Wages 2018-19
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>