newest

Hello forum I need some help where i have to copy and paste the newest file starting SBAL from one folder "X:\EMEA\Logistics " to another folder "X:\EMEA\Stats " The file name is in this format SBAL20190605080325 - YYYYMMDD , i presume the last 6 digits are seconds so the file name always...

Hello Everyone, I am looking for help regarding this formula, because currently I don’t know how to find the newest date in my sheet, below the formula ={INDEX('all opps'!$E:$E,MATCH(1,('no wip opps'!$H3='all opps'!$F:$F)*('no wip opps'!$C3<'all opps'!$G:$G),0))} So in cell C3 I have a date...

Hello, I am new in the forum, I am having a problem with VBA, I have an excel file, with an N number of shapes which are all the same and increase with the time, lets say there is one extra shape a week, All the shape are aligned in 4 columns from the newest to the oldest ( 1 is the newest...

Hi everyone, I have data in sheet"Raw Data2" and down column J I have dates, Id like to be able to have a macro that sorts the data in columns A:Z Newest date to oldest then removes any dates that are before 2018 please help if you can. Thanks Tony

Hallo! i have a column with dates (eg 1/1/2019) and want to extract the years, and put them in a row from oldest to newest. eg. i have in a column these dates: 1/1/2017 1/3/2017 1/1/2018 2/1/2018 1/1/2019 5/1/2019 and want to extract the years in 3 consecutive cells in a row from oldest to...

I'm self-taught, and apparently not a very good teacher. I have a workbook with multiple sheets that contains my tasks list. I have buttons that perform specific filters and sorts and, up until I tried a few days ago to resolve the problem I describe in another thread...

I have used the html addin sporadically over 14 year membership. For some reason, my thread is shown in the ribbon tabs, but doesn't work. When I look at the option/addins, I don't find it. I've downloaded the newest version and tried to install, but I get no improvement. Any ideas would be...

Hey guys, I have a row with three dates. I can use min and max to find the oldest and newest but I need to find the date that sits between them (as it is written in the cell not as an exact date between the oldest and newest). Hope that makes sense

I want to select newest PET date. But I can not figure it how. IF B:B is PET then select newest date?

=IFERROR(LOOKUP(9.99999999999999E+307,MATCH(INDEX(Table_Query_from_GJ,0,1),JUDI9&"",0),INDEX(Table_Query_from_GJ,0,3)),N682) IIt's pulling the date for the right client number but it isn't the newest date for that named range

Hi, Is there a way to do a LIFO calc that reduces the older invoice and adds in the newest invoice? Making the average number of days outstanding change?

Hi Guys, I am trying to extract records for the newest date within a set of data that meets 2 criteria. I have tried this array formula below but it returns a #VALUE error. Here is the formula I have tried. For some reason it is not working and I need to understand why...

I'm sure this is ridiculously simple but I can't figure out how to do it. I have a list of locations in my A column and then each subsequent column has a date I visited that location. Currently, each row is oldest to newest as that is how I have been adding them. I figured out how to sort by...

How can I copy the latest (newest) DATE to another cell? For example I have Cells D6 to D36, some of these cells have DATES some are blank. What I would like to do is copy the latest (newest) DATE to cell D39. Thanks

I have a spreadsheet containing data drawn from an access database. I want to sort by the date column, which is in dd/mm/yyyy format however I dont have the oldes/newest option on my sort menu. I tried to set the date to general format and found some of the dates returned as numbers i.e. 40656...