older

Hi - I have a spreadsheet with data in columns A:E. In column B is a date. I would like to remove all rows with a date more than 7days older the today(). Ideally i'd like to have a popup that asks remove dates prior to? thanks!

Hi, I have a several file that have a lot of formulas and worked fine before on another computer (older) and probably with a slightly older version of excel. When opening on my new laptop all of a sudden I'm getting circular reference error notices that I've not seen before and now my formulas...

Hello, I'm looking for an efficient way how to highlight data older then specified time. In my attached example file I have two tables with data and two tables with a timestamp data(one timestamp table for each table with data). Please note, there is always one blank cell between cells with...

Hi all, I have a column of dates and I need to highlight those dates that are older them 180 days. so fare I have the following =AND($S2<=TODAY()-180) the problem I have is that it also highlights the blank cells, what do I need to do / add to make it ignore the blank cells? thanks Steve

I would like to highlight a row based on a date in that row. Dates older than today need to highlight the row the date is in. I was able to highlight the rows based on dates within 60 days from today using this formula in conditional formatting: =AND($K1>=TODAY()-1,$K1<=TODAY()+60). I just need...

Hi guys. I'm a total noob when it comes to excel macro. However i find myself in need of a macro that will highlight an entire row a certain color when "Date" cell is older than 4 days. Perhaps someone will be kind enough to help me build it. Thank you all.

Hi, I have been searching the web for some days now and can't figure out the exact code I need. I want to delete all rows with dates in column B that are older than today's date. Thank you in advance

Hi All, I'm using the below formula to try and calculate count of dates that are older than 90 days old between two columns (AK and AM). I want to make sure that should the value in AK AND the value in AM both be older than 90 days, they are only counted once...

Moderators, I have noticed others placing duplicate post in the forum lately and I am one of them and had a post locked by Peter I am not sure about the others but when I replied to an older thread from a year ago, I never saw it come up on the New post page and could not tell if anyone would...

I'm running a process that imports data into a excel table and this can be done multiple times, so I want a way to remove the older instances and only keep the newest, which would be furthest down the table. When I've tried using the remove dupes function it always removes the bottom values, is...

Hi all, I am trying to create a formula to count if cells D6:100 = 0 and if the date in cells B6:100 are older than 30 days, but I cant seem to figure this out. I am using the following formula but this is just giving me "VALUE". =SUM(IF(D6:D100="0",IF(B6:B100=">"&TODAY()-30,1))) I have also...

Hi I'm trying to setup a table in Excel (2016) and load it to a SharePoint, this I am able to do. I now want to be able to synchronize this sheet with the data in the SharePoint when I update it in Excel, anyone know how to do this? I have seen it done, and have done it myself in an older...

Hello good people, I have a huge list of data in excel (200.000+ rows) in the following format: Number Value1 Date User INC40325 1 9/9/2016 2:52:11 AM user1 INC65485 3 9/3/2016 7:57:58 AM user2 INC40325 9 9/9/2016 1:39:49 PM...

Let me start by saying I am very new to this. This means that a) if you look at my macro and think, "Yeah, that's a bad way of doing it," I won't be offended. Let me know the right way. B) you might need to explain things in a very basic format, as if I'm a slow 3 year old. c) if you have good...