EOM formula

markvsmy

New Member
Joined
May 19, 2019
Messages
6
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

DateCustomerInvoiceAmountVATVATTotalTermsDue
01/04/17XXX Logistics285£1,020.00Y£204.00£1,224.0030EOM30/05/17

<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>

Thanks in advance for help,

Kind regards
Mark
 
Hmm, by my count, the "third version" has the expression EOMONTH(C4+SUBSTITUTE(J4,"EOM",""),0). That is not "30 ... days after the last day of the previous month".

For the latter, I think "theBardd's" expression is correct, to wit: EOMONTH(C4,0)+SUBSTITUTE(J4,"EOM","").
 
Upvote 0

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,213,536
Messages
6,114,210
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top