Hi
I am trying to create a spreadsheet to calculate debtor days using the count back method - but cant seem to get the correct answer. please see formula being used currently and data i am trying to work with:
The formula i am using for the days is shown at the bottom - but is obviously not correct!
Essentially in some cases i may need to count back 3 mths and in some cases up to 4 mths so the formula needs to account for any number of months.
Can anyone help?!
Best regards
<tbody>
</tbody>
I am trying to create a spreadsheet to calculate debtor days using the count back method - but cant seem to get the correct answer. please see formula being used currently and data i am trying to work with:
The formula i am using for the days is shown at the bottom - but is obviously not correct!
Essentially in some cases i may need to count back 3 mths and in some cases up to 4 mths so the formula needs to account for any number of months.
Can anyone help?!
Best regards
<colgroup><col><col><col><col><col><col><col><col span="11"></colgroup><tbody> </tbody> |
<tbody>
</tbody>