date

Hi, im no pro at excel and would be grateful for any help in how to make what i need. I have attached an image for reference but what im trying to make is a sheet where for documents named in the top row, we input the date we implemented it, then the cell below indicates the due review date -...

Hi Guys, I have an issue which seems to be easy but it's DAX so it isn't :-) I have similar Table (called "Data") as source: Added Table to data model then inserted a Power Pivot: count values in column "C" per Date and per Country: I started to get proper values for previous date but...

Hello! I am looking to complete a formula that will look for a specific text between columns and rows but only count them if they are between 2 dates. For example, if the text apple is listen between E:N between dates 3/21-3/31 in sheet 1 then deliver a count value in A1 sheet 2. I have tried...

Hi How I can do this ? For example, if I click / choose a date 11/04 in a range D2:J7, it should colorize the same date (and descriptions in 2 near cells) and same color in a range L2:N15 if the same date exist in column L. Is it possible by VBA or Conditional formatting? Thanks

Hello Excel Community, I have a weird request which I am hoping someone might be able to provide a solution. I have rows where dates are provided in the following format yyyy-mm-dd and contain multiple dates in that format (Example: 2023-04-062023-04-072023-04-08). What I am trying to...

I have a piece of VBA (see in full below) that processes data from one sheet and outputs into another. Both spreadsheets are stored in a SharePoint site. The code works absolutely fine on my PC and one member of the team who run it. However, on the other 2 team members PCs an error occurs...

Hello Excel Masters I'm looking for a formula to convert the below text in cell A1 into the date Mar 20 A1 = March 20, 2023 at 10:21AM The formula needs to work for any month and day, for example in 6 months the formula would convert September 21, 2023 at 11:21AM Thank you in advance

I need to figure out how to change the below macro to delete all dates from 1 year ago prior to the month we are currently in. For example, because today is March 17th, the below will delete all rows prior to March 17th 2022, but I want all of March. I want it to delete everything prior to March...

Hi This is more of an observation through trial and error more than a question. General formula: StockHistory(Ticker, Start_Date, End_Date, Frequency, Header, Property[0-5]) Frequency: 0 - Daily 1 - Weekly 2 - Monthly Header: 0 - No Header 1 - Header 2 - Header + Ticker Property: 0 -...

I have the code below, written by someone else and face an issue we have not seen before. ReDim b(1 To UBound(a) * UBound(a, 2), 1 To 5) For i = 2 To UBound(a, 1) ant = a(i, 2) ini = 0.01 For j = 2 To UBound(a, 2) If ant <> a(i, j) Then If ant <>...

Hi All, Is there a way to add a fraction years/months to a date? E.g. H1 = "03/08/2021" + J1 which is "8.75" (where 8.75 is 8 years and 9 months) to give me a new date of "03/05/2029" Would greatly appreciate any help on this ! Thank you

Good morning, I have this text, (and it changes but it'll always be annual. Feb-Jan, July-June, etc.) and I need to pull the starting date from the cell. For the Period: May 01, 2021 to January 30, 2022 I currently have this formula but it'll only work for some of the months, not all. For...

Hi All, Seeking some help please - generally not too bad with formulas but this one has me stumped and not even sure if it's possible? What I am trying to work out is, for a calculation that requires a date do the following: If a Date exists in Column H, use that date, otherwise use the date...

Hi All Only been dipping my toe into powerquery for a couple of weeks, and it is saving me so much time with my reports etc. Time to turn it up a notch or two. I have several queries (left-hand toolbar) and in one there is a column with dates. I want to find the newest date (which I think will...

Hi, I have tasks to do in my school and I need to copy a specific value on different sheets based on what date today is. So for example I have 16 sheets and I just need to get the specific cells value based on what today date is ( March 3, 2023) and so on.. and paste it to another sheets...

I have table like below. however, doing the date manually is tough for every month. the date is shown from the start day of the week till last day of week (Mon to Sun). Example: below is week 1 so it will show like below (Mon and Tue not show any date because it was in Jan). Week1...

I have start date and Number of days of stay I want result as highlighted below I want a formula for Excel 2013, can someone please help ABCDEF1Stay11422/25/2022114ExpectedExpected32/28/2022443/31/20223154/30/20223065/31/20223176/18/20221889E1E1=SUM(E3:E7)

Hi, I am hoping you could assist me please. I have a data set that I need to manipulate and automate for ease of use moving forward. Below is a snippet of what I am working with. Essentially, I need to take the 'QH Comm Date' (column A) and keep the DD/MM but change the YYYY to 2023 in the...

I am a complete VBA novice and searched this forum to solve my issue but I still can't figure it out. I have a workbook with 3 worksheets and need a pop-up when opening the workbook. All the info for the pop-up will be derived from the 1st sheet which is named "OpenCases" Here is a screenshot...

Hi, I'd like to write a measure to calculate the sum of the current and previous month totals, so Sum dec ; january, Sum January Febuary, Feb : March, in a nonth month ( Date) scenario I've used the the following; SPC:= VAR oneV = IF(HASONEVALUE(Table1[Date]),VALUES(Table1[Date])) VAR...