1. S

    Month Count in Google Sheets.

    Hi, I'm looking for an excel formula that can count the months from the start of positive #s to the end of positive #s. Zero values in between positive #s count. Zero values do not count before the first positive # or after the last positive #. Client 5/31/2022 4/30/2022 3/31/2022 2/28/2022...
  2. R

    One formula to count all ADs on workdays in a month

    Hi, I am looking for one Excel formula to put in cell A1 that counts all AD values on workdays (not weekends nor holiday 2-01) from the beginning to the end of the month. The dates (see image) are in row 2, the values in row 3. I am struggling with this.
  3. R

    Random value must be unique depending on date range

    Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...
  4. E

    Convert month number to text without lots of IF statements- is it possible?

    I'm hoping to convert a month number (e.g. 7) to a month name (e.g. July), is there an easy way to do it? I've found several *competing* theories online of how to do it, *none* of which are correct. Does anyone know if there's an easy way of doing it? I'd like to avoid making a chain of 12 if...
  5. S

    How do you change the month to reflect a specific pay date range?

    I am looking to set the months up within the period of my pay days, so to properly reflect my spending within that period. I get paid on 26th of each a month, so I would like to set it so that each month starts from 26th. e.g. July 2022. - Pay Period: 26.07.22 - 25.08.22 Aug 2022 - Pay...
  6. L

    Calculate monthly average and mid month average?

    Hello, I have a set of daily numbers (excluding weekends) for every day of every month. At the end of the month, I need to calculate the percentage change from the first day of the month to the last day, and also the mid-month percentage change (from the middle day of the month to the last day...
  7. D

    Convert date automatically to “mmm” format

    Hi all, Can I know how to get month in “mmm” format if I have a date in its previous column. For eg: column A contains date in short format. I want column B to show only the month in “mmm” format based on the date in column A. Similarly column C will show only the year in “yyyy” format. How to...
  8. B

    VBA code to sumifs and split across Business Case and Managers

    Hi Can someone help me with below requirement. I have base data in sheet1 with Business Case ID's and Managers etc as below. X to AI columns will have Jan to Dec data. I am only allowed to present some sample data due to confidentiality. X Y AI AJ AM AN 1-Jan 2-Feb 12-Dec Yes/No Manager...
  9. Martin_H

    Slightly modify the code [VBA]

    Hi team, I would like to slightly modify the code below, which is a small part of bigger macro: If Month(Date) < 3 Then MsgBox "Not yet available.", vbExclamation Exit Sub End If So basically, if today's month is February and I am trying to run macro specified only for the month of March...
  10. S

    Return date based on month and year from data

    I have a set of data that consists of one column of dates and another column of values that corresponds to the date next to it. I would like to have a formula that you can search for the lowest date based on the month and year. So if I have February and 2020 as the criteria, and the data is...
  11. B

    VBA code to align data monthwise/Horizantally

    Hi All, Can someone help me with below requirement. I have data sheet1 where there is "Month" header is column "I" and "COUNT" header in column "M". Sample data looks like below. Number Name MONTH COUNT 121 Ram February 40 132 Carey February 32 125 Salim February 40 127 Kumar...
  12. D

    Macro to utilize drop-down

    Hi everyone, I have a macro which edits and populates a template (which has other macros in it) and I need to populate a drop-down value for the month. The value is a numerical value of the current month, so I entered a code which would go to the cell "A15" and populate with the numerical value...
  13. D

    Formula that cumulatively adds months based on start and end date

    Hi, First time posting on here so apologies if my request has anything missing. I have a list of projects, each with a start and end date in one excel sheet. In another sheet I have months as the column headers, and rows containing "new projects" and "active projects". I have filled out the...
  14. MrDB4Excel

    Month Conditional Formatting

    If a range in a column contains a specific month using the format Mon-01 June 2020 then I want to set conditional formatting on that range. Different conditional formatting would apply for each of the other 12 months, plus the one column “R” labeled “Expected Conversion $ To Kč” would have the...
  15. V

    Dates to month with if conditions

    Hi All, Thanks in advance, we have the following sheets sheet1 Time and dateEmail AddressOptiontest5-5-2020 12:52:30goldy@zyx.comcall15-5-2020 12:58:38vin@fdfs.comcall 25-5-2020 13:14:23pate@dfd.comcall1Option 15-5-2020 13:15:34lucy@fdfd.comcall35-5-2020 13:25:03goldy@zyx.comcall26-9-2020...
  16. B

    Format decimal as number of months

    Hey everyone, I want to format a decimal/fraction as a number of months. For example, I'd like to enter "=1/12" into a cell and have it show "1 month," or enter "=1.5/12" and have it show "1.5 months." Is this possible? Thanks!
  17. E

    Monthly increase

    I need a formula in my excel sheet that increases in value by 2.16 every month. e.g. if cell A2 is "5" in January it must automaticly be "7.16" the first of February and "9.32" the first of March and so on. Is there any formula to make this happen? If a parameter to get yesterdays month existed...
  18. M

    VBA Match Month & Year in Row to Month & Year from another cell

    Thanks in advance for any help! I'm trying to locate the month and year contained in a row of one worksheet that matches the month and year contained in a cell on a different worksheet. Then copy the matching column to a third worksheet. With the below, I'm receiving a "Type Mismatch" error on...
  19. C

    Month Sum based and dates and a name

    I have a spreadsheet called "Scrap Detail" where we log what items we scrap and against what work cell. Column A has the date and column B has a drop down to select the Cell. The value of the scrap is then totalled in Column F. We then have different work cells within the business where I have...
  20. Geo1126

    IF Last month

    Hi Guys, I think this is pretty basic, yet I still havent been able to figure it out. I want a formula that returns a cell value, if another cell value (date) occured last month. if the month column is blank or not last month return NA. A1 has date B1 has value I wanted formula to capture C1...

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
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 "".
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