month

  1. 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...
  2. 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!
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. P

    averaging months

    what i want to do is. i want a foumula that will let me to get a rolling average for a month as i add numbers for each week. that total will be in one cell. I want it to be able for it to figure a average for week 1,2,3,4 so that I will have a current average each week. Example: week 1...
  8. M

    Formulas

    Hi I have a Workbook which has a sheet for each month and a totals sheet. I'm trying to get Year to Date totals based on the month. ie in cell E1 on the Master Doc tab the month is Jan then in C5 it shows the value from C5 on the Jan tab. If E1 is changed to June 19 I want C5 to show the Total...
  9. B

    Count unique number in column B for specified month.

    Hi All, I'm wondering if someone could help me on this! Is it possible to add month instead of range. Like count unique number in column B for the month of Sep, Oct or Nov. Note that I have column C which has dated when claim number was issued. A B Test-Count | Auto-Num...
  10. K

    Pop up message box

    Hello all, I have a workbook that uses multiple command buttons to get to the user forms and writes data to multiple sheets. I was wondering if there is a way to get a message box to pop up when I click on my midnight command button and "01" is displayed in cell "C4" on the main page where the...
  11. P

    VBA AutoOpen sub to worksheet # based upon the current month

    Good EveningEveryone :), I would like to create an AutoOpen sub that automatically opens up to a specific worksheet based upon the current month. For example, we are currently in October, so I'd like it to open up toWorksheets(4). If its November, I'd like it to open up to Worksheets(5). If...
  12. P

    averaging months

    I have a situation where i have 12 months in a row acroos my worksheet.( Jan-Dec), and i have 6 catgories with total number of students that attend across the top. each month has 4 dates. so what you have is each month they meet weekly and i have a attendance number. I another place on the...
  13. A

    set up blank pivot tables for future

    folks, I am trying to set up a model that will report for the next twelve months. Each month is on a separate worksheet. I need to show salesperson and sales amount in one of the graphs. Given that sales people may or may not achieve a sale in any one month, I thought that using a pivot table...
  14. R

    Case Statement and For next loop

    Hello, My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...
  15. I

    Could you check my code, userform to worksheet please

    Hi, The code is shown below. I have a userform with Comboboxes ComboBox1 is MONTH ComboBox2 is YEAR Month is to be inserted into cell A3 Year is to be inserted into cell C3 When i press my transfer button the YEAR isnt shown on the worksheet but the MONTH is entered into cell A3 Please can...
  16. I

    Advice for code copy / paste userform to cell range

    On my worksheet called Sheet1 i have a range I26:I35 with values in. My intensions are to press a transfer button on a userform & select a Month. This will copy the cell range values shown above to 1 of 13 possible paste locations on the same sheet depending on the MONTH selected from the...
  17. N

    Countif Month for Attendance Sheet

    I am making an attendance sheet to count the number of times a person is present in a certain month. (url to photo of sheet attached) Column A is Dates, and Columns C-D lists "yes" if present on that date and "no" if not present on that date. Column G lists months (Feb, Mar, April..), and in...
  18. A

    Vlookup to a sheet in a workbook that changes each month

    Hi everyone I have learnt so many tricks from this forum which has made my job much easier. I have another "challenge" now: I have inheriated a workbook with many cells lookup to a worksheet in another workbook, it is simply, however, the worksheet changes each month, for example, in Oct the...
  19. willow1985

    Current Month minus 2 months

    Hello, I know the formula to find the previous month name: =TEXT(TODAY()-DAY(TODAY()),"mmmm") But how could you modify this to give you minus 2 months or 3 months? I am looking to reference another column to maybe minus number sequences from 0 - 6 subtracting a month at a time but I need it...
  20. A

    Extracting a date from a cell which has a particular value

    I have 3 cells in excel in same column. One has value "Dec, 2014", second one has value "NA_Dec'14" and the third one has value "NA_". As you can see 3 cells have 3 different values. I am looking to extract a date either first day of the month or last day of the month from the second cell which...

Some videos you may like

This Week's Hot Topics

Top