dates ranges

  1. S

    Creating a new row for each date within a row range

    Hi all! Have a tricky one for you :) I have a data set that contains multiple dates within each row, in the sample data the dates are published in C:E. The number of dates will vary from line to line. What I'd like to do is to create a NEW row for EACH of the dates, pasted as values, since the...
  2. H

    Leave roster with duplicate names and multiple date ranges

    Hello forum - not sure what is possible so any assistance with the below question appreciated. I have 2 worksheets in a workbook: Sheet 1 is my raw data set and Sheet 2 is the leave roster I'm creating. Sheet 1 (raw data) has: Column D = names (duplicate names exist) Column F = Status (6...
  3. E

    Clustering date ranges without overlapping. (Timeline bar chart)

    Hi, I'm stuck with this issue, please help! I have a variable set of dates ranges, and I need to assign each range a number (or label) and avoid overlapped ranges in the same label. So the numbers (or labels) will be the "Y-Series" for a timeline bar chart. I need to get the minimum number...
  4. H

    Lookup a date in a range challenge

    Hi I've run into a bit of a challenge with dates. Essentially I'm have a bi-monthly calendar with date ranges appearing every two months for a 12 month period. I have two tabs, the first (tab A) contains all the date ranges and an entry for a specific date that doesn't correspond to the range...

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