prior

  1. B

    Conditional Format Current Month and Those Prior

    Greetings! First I would like to say thank you for taking the time to look at my issue and offer a solution, your help is greatly appreciated. I am looking for help in creating a formula or direction on how to highlight dates in a cell(s) using Conditional Formatting for which are in the...
  2. S

    Select Random Sample from Prior Day with Specific Criteria

    I apologize for a duplicate/similar post, but my prior post was not answered correctly/sufficiently. I have a large data set, with 22 employees that tracks their daily transactions. I want to obtain a random sampling of 1 transaction per person from the prior day. Column A = Transaction Number...
  3. H

    Macro to filter dates and tdelete those rows

    I have dates in Col F on sheet2 I have manually filtered the dates prior to 01/10/2017 (dd/mm/yyyy) and then manually deleted the rows I would like to automate this process so that a message will appear "select date you wish to filter prior to this date" once this is inputted , Col F must...
  4. A

    Return value to a weekday closest to certain date

    Hi, I’m trying to return salary (from one cell) in to a cell next to the 28th (calendar as list) or Friday prior to the 28th if the 28th falls on weekend or bank holiday. Any help greatly appreciated. Thanks
  5. T

    VBA for moving entire row based on cell value to another worksheet

    Hi, It has been 8 years since I have dabbled in Excel macros. So I need help! I am using the Excel for Auditors 2007 Edition so maybe that is my issue. I have a report that list Reps in column G. I need to loop through all rows on the sheet, create a worksheet based on that value and move the...
  6. M

    suppress dialog boxes vba NOT applicatoin.displayalert = false

    Here's my code: aggregate = "'" & ThisWorkbook.Path & "\" & counter & "\[aggregator.xlsm]" & ws.Name & "'!percent" prior = "[" & counter & ".xlsm]" & ws.Name & "!" & counter & "MBO" If counter = qt Then rng.Formula = "=iferror(" & aggregate & ",""oddly...
  7. Y

    Date Range - Count Days per Month

    Hi, I am seeking a formula to calculate the days per month assigned to each job. For example job 1 is 98 days and the formula automatically assigns the 98 days across the Prior Year (2017) and Jan-18 to Mar-18. Similar formula for each subsequent job based on the start and end dates of each...
  8. M

    Excel VBA - Open monthly file names based on Month being worked on

    Hello, I need some advise. I want to automate some data entry in excel. We have a spreadsheet where data is manually entered into cells E15, E16, F15, F16, O15, O16, P15, P16, Y15, Y16, Z15, and Z16. Row 15 is for current month data and row 16 is for prior month data. There are two files...
  9. M

    optionbuttons should work dynamically

    Hi, There is userform with two optionbuttons that depending on the selection are shown as FALSE and TRUE in cells A1, A2. The issue is those optionbuttons selection should result in dynamic changes in A1 and A2, prior to userform closing. How can I fix it...
  10. D

    Using a Formatted Date in a Formula

    Searched the archives but I could not find an answer... I have a cell with a formatted date entry (MM/DD/YYYY). I need to use the DD to calculate an average per day where the data I am using is thru the prior date: F3 = (B3 / (DD-1)) What would be the correct way to write this? Thank you...
  11. P

    Need help with a formula that will give me the average of the prior 4 weeks

    My data set is as follows: In columns starting on C3 I have week ending dates starting with 1/6/2018 all the way to column BB3. on Column C5 i have the week number starting at 1 going all the way to column BB5. C6:M6 contains my data. I need a formula that will average the prior 4 weeks. I need...
  12. J

    Calculate items sold within 10 days prior to specified date

    Hi all, I have a list of sale line items, one column has a date, the other the number of items sold. How can I sum number of items sold, where order date is <2/12/18 and >2/02/18 but instead of inputting the date, I would select a cell containing 2/12/18 (i.e E3) and tell the formula to look...
  13. Y

    2017 active employee by month

    I have a sheet the has employee names in column A. Column B contains their hire date, which could be 2017 or any prior year. Column C is termination date, which could also be 2017 or any prior year. Column D is re-hire date. Columns E-P are months Jan - Dec. What formula can I use to...
  14. E

    Sos!

    <tbody> Latest Recv Date 2017 2016 2015 2014 & Prior </tbody> So I have a col G with a Date (Any date from 2012 to 2018). I need it to read such that,if the date in ColG is 2014 and prior then the value from Col Q goes into ol Y(2014 & Prior), else returns 0...
  15. E

    excel If date is after or before 5pm the prior working day

    Excel dates. I have a date of job and date/ time of job request. If the job was on a Monday, or weekend I need to determine if the job was requested before or after the previous Friday at 5pm. The rules are if a date of job (Job date) was requested (job requested date) after 5pm the prior...
  16. P

    Bring the first date prior to a date

    Hi. I have a column (A) with dates sorted by oldest to nearest. I also have another column (B) with dates but with gaps of 4 or 5 weeks between them. I would like to have a formula on another column that will bring me the first date in column B if that date is prior to column A. An example so...
  17. K

    countifs with multiple criteria in the same cell

    I have data in column W that has multiple answers to a question. Example (A, C, or A, H, or B, D,). I'd like to count all the As with a date equal to or prior to 10/1/17. I tried the formula below and know that I'm missing something but just not sure...
  18. A

    Optimization Possible for Calculated Subtotal Insertion VBA?

    Hello Folks! So I have this wonderful file that organizes project process by state / company, and one of the macros I run that I had assistance putting together a while back inserts calculated subtotal rows on every individual State's worksheet. The only problem is that it takes 12 minutes to...
  19. P

    VBA to Open Prior Month File and Copy and Paste Info into Current Month

    Hello, I have a monthly file that we have. I have code that asks the user to open the prior month's file, but I'm not sure what to do after the file is open. The file name will change every month (name of month is in the file name) and each month there is a YTD, MTD and QTD. But essentially, I...
  20. S

    nested if statements

    I am trying to write a formula that will look at a date in column H2 and determine if that date is a prior week, week 1 or week 2 For example anything older than or equal to 8/19/17 is prior, any date between 8/20-8/26 is week 1, and any date between 8/27-9/2 is week 2. I have it already done...

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