month end dates

  1. A

    Find month end and locate 2 values

    Hi There, Would you please advise on the below, any help would be greatly appreciated. I receive a spreadsheet with values each month, of which I extract only MTD and YTD performance for numerous entities. This question is just for 1 entity as a sample. I was able to make the VBA work by...
  2. S

    Establish quarter with changing dates

    Interested in establishing monthly totals based on power bill dates. The dates are not uniform. For example, date rages could be 1/17 through 2/17, this data should fall under the month of January. I am using the =CHOOSE(Month.. but unsure how to input that days above the 16 should round up to...
  3. klynshoe

    Month-end dates

    USING EXCEL 2010 Hello, I'm looking to fill in all the calendar month-end dates for several years. What's the best way to go about doing this (macro-free if possible). Thanks!

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