Hello,
I am sorting my accounting spreadsheet and using the formula IF(J4="30EOM",EOMONTH(C4,0)+30) which works, the problem I have is adding more If variables for this file, most customers are 30 days EOM, but some are 45 EOM, some are just 30 days, some are 60 days. If I can get the first IF variable to work I am sure can then add the rest.
For info I will use a drop down menu to input which of the payment terms applies, C4 is the date, J4 is the payment terms
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
Thanks in advance for help,
Kind regards
Mark
I am sorting my accounting spreadsheet and using the formula IF(J4="30EOM",EOMONTH(C4,0)+30) which works, the problem I have is adding more If variables for this file, most customers are 30 days EOM, but some are 45 EOM, some are just 30 days, some are 60 days. If I can get the first IF variable to work I am sure can then add the rest.
For info I will use a drop down menu to input which of the payment terms applies, C4 is the date, J4 is the payment terms
Date | Customer | Invoice | Amount | VAT | VAT | Total | Terms | Due |
01/04/17 | XXX Logistics | 285 | £1,020.00 | Y | £204.00 | £1,224.00 | 30EOM | 30/05/17 |
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
Thanks in advance for help,
Kind regards
Mark