1. T

    Excel date vba filter

    Hi guys, Been stuck on this for days now so I'm resorting to asking for assistance on this one. I'm trying to filter between two dates in dd/mm/yyyy format ( my PC is formatted this way too in regional settings), but after I run the code, the date "custom filter" has mixed up the days and...
  2. Z

    Analyse Salary Received and Amount Invested Year Wise and Month Wise

    I have 2 table in an excel workbook. 1. Consists of Month wise salary received by an employee for a span of 5 years Date NET PAY Basic Basic Arrears Adhoc Pay 30 April 2015 0.00 0.00 0.00 0.00 30 May 2015 0.00 0.00 0.00 0.00 30 June 2015 0.00 0.00 0.00 0.00 30 July 2015 0.00 0.00...
  3. D

    Selective copying based on criteria

    Hi guys! I have kind of a complex question. It all starts with a very large spreadsheet (let's call it 'raw data'). It has many columns of information (A:GD). Much of this data is pretty useless to me, to be honest. But there are a few pieces of information that I want to extract (if the row...
  4. Y

    EXCEL: Date Late Submission

    Hi, I want to show if textDate.value is equal or is not greater than 1 day textDateSubmission.value show "On Time". Then if the textDate is greater than one day to textDateSubmission show (Days of late)" days late" if TextBoxDate - TextBoxReceived > 1, TextBoxReceived - TextBoxDate "days late...
  5. V

    Handling a large dataset: turning many datapoints into one

    Hi all, I have a problem with analyzing a large dataset for my thesis. My problem is this: I have a huge dataset of a river gauge, with measurements on certain parameters. These parameters are measured for period of 30 years, daily, every half hour. The problem is, I only need 1 value per day...
  6. M

    Creating calendar with month and date change on button click

    So I am trying to create a sort of month view: I have manually typed in the dates, and working hours each day. I have also added a button on the right side. How can I change month by using the button, and automatically change the dates so I can fill inn working hours for the next month?
  7. A

    Need to return earliest and latest time based on date criteria

    I have 4 columns, i want the first two to return the earliest and latest times from two other columns that have date and time (separately). I need a formula that will look at the data based on the date criteria and return the earliest time for that date and another formula to return the latest...
  8. F

    Pull in the last day of the year based on text

    Hi all, I need help with a formula, I need it to pull in the last day of the year when it looks up to a certain string of text... e.g. if it says ABC Ltd or ABC LTD International i want it to pull in 12/31/2020 otherwise any other company name it will pull in today's date. i know there is an...
  9. A

    Count Number of Monday between two dates

    Hello, I need to find Number of Mondays inside dates provided. Start date: 4/20/2020 and End Date: 5/18/2020 = Result: 5 ( Including both Start and End dates since both are Mondays) Start date: 5/25/2020 and End Date: 6/15/2020 = Result: 4 ( Including both Start and End dates since both are...
  10. M

    Pop up messagebox every Monday

    HI , How can I do pop up message" do xyz " in excel every monday ?
  11. D

    Calculate latest quarter end

    Hi All, In an older thread I have seen the below solution for calculating the latest quarter end from a given date and it seems to work. However, I am not sure how the formula works. Could you please explain? =LOOKUP(B1,DATE(YEAR(B1),{1,4,7,10},0)) Thank you!
  12. Please_H

    Hijri Date to Gregorian ( vise-versa ) below Hijri Year 100

    Dear Valued Members of Mr.Excel, I hope everyone are safe with the Epidemic of Covid19. I have a huge data set I need to convert as well as sort related to very old Date Info on Hijri, Most dates are either below Hijri year 100 and around the year 100-200, I need aging to be done as well. I...
  13. H

    vlookup to check condition if DATE is between two dates (in two separate columns)

    Hello I am trying to find if a date is between two dates then find the row and category against those dates. Table 1 -Column C is my goal. Any excel formula to arrive at this solution? For Item A- created on is 4/2/2020 so I need to check Table 2 for Item A and see if 4/2/2020 is in between...
  14. R

    Employees over the year calculation

    Dear experts, I have an excel list of all employees with the hire date and termination date since the start of the company in 2002 up to now, 3 columns. The list includes the employees which are currently employed and the ones who left. So the employees who left have a hired and termination...
  15. S

    How to repeat a single value across Pivot Table columns

    Hello lovely people. I have searched and searched for an answer to this, but maybe I'm lacking the appropriate keywords... either way I'm stuck. I have created the below pivot table, which shows the number of monthly support hours subscribed to by a client (1. Regular), any additional hours...
  16. A

    macro, filter criteria2 = array for date column

    a macro reads the filtering selected by the user of an excel data file. When the user selects from a date column, using the tree list to select years, I can record a macro that simulates what has been selected as: ActiveSheet.Range("$A$3:$T$179896").AutoFilter Field:=4, Operator:= _...
  17. N

    Format a date in a text string

    Hi, I think this is probably a simple fix but for the life of me I can not work out to get it displaying properly. I have the below formula: ="as at "&TODAY() and it is returning "as at 43916" I would like it to return the date in date format not as a number. Thanks in advance for any help.
  18. M

    Combine data from different cells to one cell

    Hi, I am trying to figure out how I can get from table one to table two with formulas or some easy VBA. As you can see I want to make one row for John and one for Jenny, instead for two as it is now. The date should also be combined so that the first start date and the last end date shows. E.g...
  19. A

    Macro only works in debug mode

    Hello all, I'm attempting to run a macro over multiple workbooks which clean up, and add additional data into each workbook. For the most part, this macro runs correctly, however, one section will only run properly if stepped through in debug mode. If run normally it will have no effect. What...
  20. M

    How do I add conditional formatting for a row in my table if the value in Date column is not one day greater than one row above?

    I have a large Excel table with a Date column. The values in Date column range from 6/1/2003 to today. How do I add conditional formatting that will surround a table row with a huge red border (or a highlight in yellow) if the current value of Date is not exactly one day greater than the...

Some videos you may like

This Week's Hot Topics