dates

  1. Chandler8

    Function/Formula for connecting dates to names to a list

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

    Power Query Combine list of dates

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

    Excel double condition formula

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

    Calendar help

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

    Conditional Formatting based on the Date

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

    Condtional formatting for dates.

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

    Counting unique values by date condition and another criteria

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

    Dates with condition using userForm textBox in VBA

    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"...
  9. F

    Count (countifs) norm exceedances with variable dates and variable norms formula or VBA

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

    VBA pop-up message box for dates

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

    Is there a better replacement for this formula?

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

    Clear formula to track invoice status

    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")
  13. J

    Day calendar referencing array with duplicates

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

    Dynamic Schedule Of Dates

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

    Need a VBA script to pull most recent training dates

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

    Auto Fill Financial Periods from given start and end date

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

    VBA Code to automatically fill dates horizontally (not to last column)

    Hello everyone! This is my very first post on mrexcel.com but I've been a site regular for many months now. You guys rock! I always find a thread of someone having the same doubt as myself, but I now have a somewhat specific query: I have a data sheet that is updated monthly where monthly...
  18. D

    Add occurrences of same month data

    Hello, I have a spreadsheet that looks something like this. Id like to be able to add together the date occurrences by month in VBA (so add all the dates from January to show how many January entries there have been). But also add them together based by their category. So the output from...
  19. B

    Providing dynamic date range to PowerQuery

    I have been looking for a while now, and while I've gotten close, I haven't found that cigar. I have a PowerQuery gathering transactions from multiple worksheets in a file, and I'd like to be able to filter to get only those transactions with dates between a StartDate and an EndDate. I've gone...
  20. G

    Comparing Day of Week with Date from Previous Years

    Good day, I'm having a struggle trying to figure out how to do something regarding DOW and Dates. For example, in the dataset I have Sunday, August 1s 2021 has the number 100 and I want to compare that against the first Sunday in August 2019, not against the 1st (date) itself because that is a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top