ago

Hi guys I have been struggling to find a solution to an excel problem I have. As the title says I have a cell in my spreadsheet that is constantly changing "H10" and I would like to record this for the last 5 seconds at 1 second intervals. But this would be triggered to start recording with...

Question: How many employees were promoted more than 7 months ago (Column C)? If they were not promoted, then how many employees were hired more than 7 months ago (Column B)? <tbody> Employee Hire Date Last Promotion Date Employee 1 <tbody> 09/12/2013 </tbody> 01/01/2018 Employee 2...

Using Excel 2013, is there a way to create a custom date filter to filter all dates that are >90 days ago: >today()-90. When I type this into the custom filter formula, it isn't working.

I've looked around and could not find the solution. I know I've done something similar before, but it was a long time ago. I need extract the date and time from the follow text string: Jan 6 2019 8:30AM Thanks

I realize that there are more efficient ways to obtain files from websites using VBA but I really want to figure out how to control the Dialogue Box that pops up when a user is trying to download a file. To be more specific, I want to select "Save As" and set the file destination. The...

Hi all, I am trying to evaluate if a column on another sheet in the workbook’s date is less than 6 months ago and count them all up when the value (in this case it’s a person’s name) in one of the columns = the value I am looking for. I then what to split out the percentage of how often it was...

If I have a large amount of data (ticket volume) and need to know how many tickets were created between 0-30 days ago, 31-60 days ago, 61 - 90 days ago, and 90+ is there an easy way to do with a pivot table or do I need to change the date filter by 30 days and copy and paste the data for each...

I’m trying to use a bunch of if / and statements to work on the following problem but it isn’t really getting me anywhere. The premise of what I’m working on is that certain things have taken place in the past, and depending on how long ago it happened, it gets a certain score. - If it...

I put in the code: Dim wb As Workbook, str1 As String Set wb = ActiveWorkbook And when I look at the info for wb in the locals window for wb it just as no variables. I'm pretty sure that it was working a second ago.

I have a date in a cell on a table and I want to use countifs. I want to say count the number if records where the date (in date and time format DD:MM:YY HH:MM) where the date is over 30 days ago from today and less than 120 days ago where the status of the customer (colum M) is Sale completed)...

I have a workbook in Excel 2010 that after I use a sort macro when anyone reopens the workbook we get an error that says it has unreadable content. Then if you say yes we see a box that says. Removed Records: Sorting from /xl/worksheets/sheet1.xml part I never seen tis before until just a week...

Dear All, I'm working a quite big process with a userform with 8/10 buttons doing different things on a sheet. The file il 1400 kb big and it used to be normally fast. Some weeks ago all the processes suddently slowed down but I can't understand why and i don't know where to start to find out...

Hello - I am looking for a formula that will return "A" if the date in B5 is equal to or less than a year ago, and "B" if the date in B5 is greater than 1 year ago So far I have: =IF(C5>=DATE(YEAR(B4)-1,B4,B4),"A","B") C5 is a date that varies B4 is today's date =TODAY() It returns: #NUM...

I’ve been struggling with how to start and get this done. I have a column that contains a length of time that could be worded like: 53 seconds ago, 2 hours ago, 1 minute ago. Then I have a column that has the date/time the data was extracted. I need to be able to subtract the column that has...

I need to conditional format cells where a date is less than today but no longer than 6 days ago. In conditional formatting, what formula do I use to achieve this?

Hi, there is a duplicate in "Excel Thought Of the Day" but with different sources. Today: "Friends don't let friends merge cells." Tom Urtis A week ago: "Friends don't let friends merge cells." Jon Acampora :eeek: So, who shall be known for this grand quote?

Hello, Can somebody please help me on using a Vba count method of solving the following. I'm attempting to get a football stat of how many games ago a team last Won Drew or Lost. Column A2 contains the first team and the range of B2:AU2 the results (B2 is the most recent result) at the end of...

Hi, I’m building a dashboard and have last weeks numbers (5 days of data) and I need to compare it to this weeks based on the day of the week we are in. Example, 500 tickets last week This week is Wed, so based on average we would have 300 tickets up to Wed. I need a formula that looks at...

I'm trying to use Icon Sets to indicate the 'Age' of the last update made to the file but only want to display this 'Aging' icon when the Status IS NOT certain text values. Here's some sample data: a b c 1 Date Updated Status Icon 2...

How do you run and Excel 4 macro? I've used the Get.Cell function before in the name box but I haven't used any of the others. Are these used on the old Excel macro worksheets? I think I exposed to the macro sheets years ago when I was using Excel 95 and 97 years ago in the early 2000 but I've...