dates

I've got multiple payment dates and I want to match them to a time series and populate the cell with the individual payment amounts. Sounds simple use of xmatch and indexing or similar but I'm having a mental block. Any help appreciated

Hi, I had column of dates mm/ dd / yyy , but they were acutally text so used text to columns to convert to dates, fine, but for the order I would have liked the year first, but despite selecting 'date' ' ydm' from drop down I always got the the original order but now as dates? any suggestions...

Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...

Hello, I am trying to make a table to input a set of daily data, so I have my dates (using a formula) as the top row, and have applied conditional formatting so that the WEEKEND dates are in blue and have strikethrough text. I would like to carry that formatting down to all the rows beneath each...

Hey guys, I could use some type of formula to grab the dates from a list that connect with each persons name on Guest_Info and bring it to Guest_List. The idea is each time their name is typed and they associate with a date; it will automate into these cells (Check_In_1, Check_Out_1 etc.) The...

Hi, I've been trying for some time, on an off, to concatenate a list of dates, the grouped data I have is like so; Table.Group(Source, {"Product"}, {{"Count", each List.Sum([Sales]), type number}, {"st", each...

Hi, I am looking for an Excel non-VBA function formula based on two parameters. If a cell holds the value 10, then a date starting from 24 December is added, but only if this date is a workday. If this date is not a workday, then it takes the first day before this date that is a workday. If...

With the A1 cell name equalling the name of a month how can I get the A2 cell to give me the first day of that month? or if easier I just need a calendar that will allow me to change the cell dates by changing the month in A1.

Hello!! I would like my column of dates to have 3 colors. Let's say that the date expires after 12 months. Based on the current date 6/1/2022 (or current year) Ex. The date entered is 4/13/2022 (this would be green) Ex. The date entered is 6/15/2021 (this would become orange) Ex. The date...

Hi everyone, I have added another word to my dropdown menu and condiational formatting so I can clear expired dates when they are complete. Currenlty when I choose Completed from the drop down menu it removes the pink highlight from the date so I know I don't need to chase them up. I am...

Hello, I have looked all over but I don't seem to find an answer to my particular question. I am trying to count unique client id values by month and by another criteria, in this case gender. Client ID Date Gender 1121 7/1/21 Male 1147 7/5/121 Female 1121 7/16/21 Male 7865 8/2/21...

Hello everybody, can you help me? If I delete the value of txtPrazoPagamento or the value of txtDateVencimento. I get this message: Run-time '13' Type mismatch Private Sub txtDataVencimento_Change() If CDate(txtDataHoje) > CDate(txtDataVencimento) Then txtAtraso.Value = Abs(DateDiff("d"...

Hey everyone, I have substance measurement data from water quality checks. The data is listed in a table starting with the date (dd/mm/yyyy). Above the table are the norms. The variable norms are in green. Those norms are generated on a second tab, and change (sort of) weekly. I need to...

I am have a spreadsheet that I would like to get a pop-up msg box on upcoming expiration dates upon opening the workbook . My spreadsheet is like this: Column A - Driver Name Column F-I - Have various different expiration dates Sseveral columns beyond, with other driver information I am trying...

Hello, I'm betting there is a better way to run this formula that references a block of dates by month, and returns the table rows based on the short date related to the selected month. In the example below, I have a dynamic array showcasing the rows of data from a table based on the month...

I am trying to get a formula like the below that works backwards through a table, i.e. IF N6 contains date="Paid", if false check M6, IF M6 contains date = "Invoiced" and so on. =IF(N6>0,"Paid"), IF(M6>0,"Invoiced") IF(L6>0,"Accepted") IF(I6>0,"Submitted")

Any help would be appreciated. I have a dynamic table of dates. Each column references entire production cycles and each row the cycle stages, with the top row being the start and the bottom the end. I am trying to create a "day calendar" on new sheet with the first column listing every day from...

I work for a small company who manufactures kitchens in Oxfordshire. We work on the basis of being able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete. As there are many external factors that can delay or bring...

Hello! I need a VBA script to find/match an employee with a training course completion date. Here are the circumstances that elevate this past vlookup: Employee last names - different employees share a last name Courses are duplicated - 1 single employee has taken a course multiple times...

I'm trying to auto fill given financial periods based on start and end dates of agreements, this will then allow me to prorata the contract value. Contract Period A1 Start: 15/02/2020 A2 End: 14/02/2022 Auto Fill = A3 FY19/20 Start = 01/02/2020 A4 FY19/20 End = 31/03/2020 A5...