multiple dates

  1. G

    Parse dates into mm/dd/yyyy

    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...
    • GreyFox8991
    • Thread
    • comma delimited date format mm/ddd/yyy multiple dates rows transpose yyyy-mm-dd
    • Replies: 13
    • Forum: Excel Questions
  2. S

    Conditional Format with multiple dates in one cell

    Hi All, I am trying to (easy part) conditional format a column of dates to highlight past dates. <today()" <today(). Easy enough when they contain just one date, however some contain multiple dates - e.g. Column A <tbody> A = 01/04/2019, 13/03/2020, 13/03/2020, M = 06/12/2019 26/10/2018 A...
    • Stephen.R
    • Thread
    • conditional conditional format dates multiple dates one cell
    • Replies: 10
    • Forum: Excel Questions
  3. M

    multiple date look up from different rows from two tabs

    I have been trying to figure out how to apply my expected result using a separate tab lookup. The section to the left is what I am trying to populate the expected result from the section on the right. I need to match the agent columns together then plug the tax treatment in the expected result...
  4. G

    PowerPivot relationships

    I have problems creating the appropriate relationship and consequently cannot display my data as I want to. I have the following tables with lots of data created from csv. It is very hard to alter these files as they come in ready. table 1 Calendar table: full-Date, day, month, year, ... table...
    • greeknl
    • Thread
    • multiple dates power pivot relationships
    • Replies: 0
    • Forum: Power Tools
  5. G

    Calculating number of days between multiple dates with blank cells

    Hi All, I don't even know if this is even possible but here goes... This is based on an accommodation type of business for a mine site. On Sheet1 I have named a few cells being: StartMonth = 01/04/13 EndMonth = 30/04/13 Week1Start = 01/04/13 Week1End = 07/04/13 Week2Start = 08/04/13 Week2End...
  6. J

    IF Statements and multiple, possibly overlapping dates

    Hey, I've got a real head scratcher and I hope someone out there can help me. Here is the situation: I have 4 dates -- Budgeted Possession Date, Actual Possession Date, Budgeted Commencement Date, Actual Commencement Date. Budgeted Possession always comes before Budgeted Commencement and...

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