date

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...

I'm trying to convert a historical date to the same date in U.S. Government fiscal year 2022 and could use some help with the formula. For illustration, I've provided below a sample historical date which I want to convert to the same date in FY22. Sample historical date: 07/23/01 Fiscal year...

Hey guys, My government considers 30 days for each months when it comes to payments (ignores the 31th days of some months) which proved problematic for me to make some calculations regarding the salary of the workers, I need to know if there's a way to create a custom calendar system or modify...

Hi, I have a workbook of sheets in descending working-day order in "M-D" format as follows: [ 12-30 ] [ 12-29 ] [ 12-28 ] [ 12-23 ] [ 12-22 ] ... [ 7-1 ] etc. This goes back multiple months. Given the new year, I would like to write a macro that will rename all sheets in "YYYY-M-D" format. In...

Hi, I have an existing workbook of sheets ordered in decreasing dates (by business day) as such: [ 20221221 ] [ 20221220 ] [ 20221216 ] [ 20221215 ]. With each new day I will paste a new sheet of data into that workbook as such: [ 20221222 ] [ 20221221 ] [ 20221220] [ 20221216 ] [ 20221215 ]...