Tjyylli

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Applicability of Single Responsibility Principle

What can we do to stop prior company from asking us questions?

Lay out the Carpet

Sequence of Tenses: Translating the subjunctive

How easy is it to start Magic from scratch?

Detecting if an element is found inside a container

Proof of work - lottery approach

Escape a backup date in a file name

India just shot down a satellite from the ground. At what altitude range is the resulting debris field?

How to check is there any negative term in a large list?

Closest Prime Number

Two monoidal structures and copowering

What is the best translation for "slot" in the context of multiplayer video games?

Opposite of a diet

You cannot touch me, but I can touch you, who am I?

How to draw lines on a tikz-cd diagram

Is this apparent Class Action settlement a spam message?

CREATE opcode: what does it really do?

How long to clear the 'suck zone' of a turbofan after start is initiated?

Trouble understanding the speech of overseas colleagues

What does "I’d sit this one out, Cap," imply or mean in the context?

Is the destination of a commercial flight important for the pilot?

Did Dumbledore lie to Harry about how long he had James Potter's invisibility cloak when he was examining it? If so, why?

Excel - Populate several cells from date span

Excel 2013: I have rows of records, each w/ a start and end date. How can I compile and summarize these in a separate table, month by monthReturn Earliest Date from a rangeFind a specific name in a column, bring in the value in the corresponding row, in the column I designate in another worksheetHow to check if a date is within a given range in Microsoft excelReturn data based on matching date rangeExcel Conditional Formatting for Date columsCalculate date based on number of weeksMicrosoft Excel 2013Using IF statement to create a schedule with datesCalculate the number of days per year between two different dates Excel

0

Background: I am working on a form for work where project leaders enter the start and end date of planned maintenance work. If it is affecting the customer, we will need to post information to the affected areas where customer is affected, with instructions on one such information post per day of the planned work. In essence, a planned work stretching for 4 total days will require 4 separate info posts. These posts also need the respective date in their respective header.

As such, I have two date fields in my worksheet, where they fill out the start date and time (YYYY-MM-DD HH:mm) and end time in the same format. (Below screenshot is from LibreOffice since it's what I have here at home, but the question is for excel.)

Start and end date, Desired result

What I wish to do is on a separate sheet make a dropdown of all separate days inbetween the start and end dates so I can make the dynamic info post headers, but I need the populate the cells with inbetween dates to make the actual dropdown list. As long as I have the populated list, I can do the rest just fine for my purposes.

Result mockup

I would absolutely prefer to use a function rather than a macro/VBA, but the only thing I can think of is a long list in the data sheet consisting of =IF(DAYS(End;Start)+1=x;Date+x;"") and reading from there ignoring blanks in the dropdown. Is there another way to do this?

windows microsoft-excel worksheet-function

share

asked 2 mins ago

ChokeholdChokehold

82

New contributor

Chokehold is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

Background: I am working on a form for work where project leaders enter the start and end date of planned maintenance work. If it is affecting the customer, we will need to post information to the affected areas where customer is affected, with instructions on one such information post per day of the planned work. In essence, a planned work stretching for 4 total days will require 4 separate info posts. These posts also need the respective date in their respective header.

As such, I have two date fields in my worksheet, where they fill out the start date and time (YYYY-MM-DD HH:mm) and end time in the same format. (Below screenshot is from LibreOffice since it's what I have here at home, but the question is for excel.)

Start and end date, Desired result

What I wish to do is on a separate sheet make a dropdown of all separate days inbetween the start and end dates so I can make the dynamic info post headers, but I need the populate the cells with inbetween dates to make the actual dropdown list. As long as I have the populated list, I can do the rest just fine for my purposes.

Result mockup

I would absolutely prefer to use a function rather than a macro/VBA, but the only thing I can think of is a long list in the data sheet consisting of =IF(DAYS(End;Start)+1=x;Date+x;"") and reading from there ignoring blanks in the dropdown. Is there another way to do this?

windows microsoft-excel worksheet-function

share

asked 2 mins ago

ChokeholdChokehold

82

New contributor

Chokehold is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Background: I am working on a form for work where project leaders enter the start and end date of planned maintenance work. If it is affecting the customer, we will need to post information to the affected areas where customer is affected, with instructions on one such information post per day of the planned work. In essence, a planned work stretching for 4 total days will require 4 separate info posts. These posts also need the respective date in their respective header.

As such, I have two date fields in my worksheet, where they fill out the start date and time (YYYY-MM-DD HH:mm) and end time in the same format. (Below screenshot is from LibreOffice since it's what I have here at home, but the question is for excel.)

Start and end date, Desired result

What I wish to do is on a separate sheet make a dropdown of all separate days inbetween the start and end dates so I can make the dynamic info post headers, but I need the populate the cells with inbetween dates to make the actual dropdown list. As long as I have the populated list, I can do the rest just fine for my purposes.

Result mockup

I would absolutely prefer to use a function rather than a macro/VBA, but the only thing I can think of is a long list in the data sheet consisting of =IF(DAYS(End;Start)+1=x;Date+x;"") and reading from there ignoring blanks in the dropdown. Is there another way to do this?

windows microsoft-excel worksheet-function

share

asked 2 mins ago

ChokeholdChokehold

82

New contributor

Chokehold is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

ChokeholdChokehold

82

New contributor

Chokehold is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

ChokeholdChokehold

82

New contributor

Chokehold is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

ChokeholdChokehold

82

New contributor

Chokehold is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

ChokeholdChokehold

82