current month

  1. E

    Count If Month is Current Month

    Here is the Issue I have 3 Pie Charts, they are populated from a spreadsheet that has a Status page (pie charts are located there), and the status page is updated from 3 additional sheets from the spreadsheet. I need the pie charts to only update with the current month data only, the sums of...
  2. W

    VBA Macro to Copy Row Based on Date Criteria

    Greetings MrExcel forum members. I'm a beginner when it comes to writing macros and have used this source before, but I'm having trouble with a new macro. Any help this amazing community can provide will be greatly appreciated. My boss wants a monthly report listing all personnel that are...
  3. G

    Search and replace current month with last & and save as macro

    Hello there folks! I need help with a code that will save the opel file as "jan-current month_current year". And I need the month to appear as text with three letters, for example it would be "jan-jun_2015" if I run the macro now. Is this possible to do? Also when I use the search and...
  4. S

    Conditional Formatting for month only

    I'm trying to have a cell highlight red if it is the current month, orange if next month. The actual input is text exa "January". Not a date. Is there a way where we can do this to where it will always highlight the current month even if the sheet is viewed in say... March?
  5. K

    Change color of current month only...

    Thank you for your help in the past! Step 1: In cell B1, my VBA puts the # of the current month using MONTH(TODAY()). This can change if you know a better way. Step 2: In column B2:B20, there are random 3 letter months B2 = FEB B3 = MAR B4 = AUG B5 = FEB B6 = DEC B7 = JAN B8 = AUG B9 = JAN etc...

Watch MrExcel Video

This Week's Hot Topics

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
Top