eomonth alternative

  1. N

    Advanced Formula - If statement + weeks in months - Impossible?

    Hi, I've put together this formula. =IF([@[NOV-17 Finished Goods SO Demand]]>[@[VARIABLE SO Months Average]], ([@[QTY IN STOCK]]+[@[QTY ON ORDER NOV 17]])-[@[NOV-17 Finished Goods SO Demand]], ([@[QTY IN STOCK]]+[@[QTY ON ORDER NOV 17]])-[@[VARIABLE SO Months Average]]) It works, but I need...
  2. B

    End of month (either current or prior month)

    Hi all, I want to write a formula that returning either the end of month of this month or the prior month. If a date is already at end of month, then I'll take the date as is. Example: 1/31/14 should return 1/31/14. If a date is before end of month, I want Excel to give me the end of month...
  3. P

    Conditional Formatting Last working day of month

    I need to add a formula which determines if the following (in column J): If F2 is empty, colour J2 cell red. If date in J2 is earlier than the last day of this month, colour J2 red. If cell J2 is empty - colour J2 red. The formula would then be applied for the whole of column J
  4. B

    Alternative to EOMONTH formula

    As part of an ongoing issue that I won't bore you with I need to find an alternative to the EOMONTH formula that does not use any analysis toolpak references...any ideas guys?

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