2021

i have a table of 6 column first 3 tables already have data in it in a certain sort i would like to keep second 3 table which i will put data in i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1 let...

Hi I am trying to return a date using XLOOKUP which it does, however, the original date is shown as Date and Time 01/02/2023 12:40:58 and I want to remove the time without changing the format of the cell as when I then use a pivot on the returned date it will still show as date and time...

' To load work book based on cell value ' Real Estate Books Dim varCellvalueReal As String 'Filename:=Sheets("Sheet1").Range("A2").Value & "\" & Sheets("Sheet2").Range("A2").Value) varCellvalueReal = Workbook(Filename:=Sheets("Sheet7").Range("D3").Value) ' & "\" &...

Help please if you can, I cant seem to find anywhere else. Im trying to find the equation for 2 things, 1. I have a chart I'm making and trying to calculate if something is past due 30 days, 10days, and 5 days is there an equation to find out if the dates I entered have passed...