Plotting the list of dates for the given numner and given period

[thilag]

Hello

Please find the attched 2010 Version file <List of from date and to date for the given number and period 280915.xlsx>

I want to plot the list of dates for the given numner and given period in light yellow cells by formula.

thanks in advance

thilag

[JeteMc]

The attached file does what you are asking about in your first example. It employees three "helper columns" to show (column C) the run of cells for which the conditions are met, (column D) when each run starts and (column E) when each run ends. Cell N4 shows the number of times a run is started, and the spreadsheet assumes that each run will also end. The formula used in column L to display the beginning of each run is:

Please Login or Register  to view this content.

The formula used in column M to display the end of each run is:

Please Login or Register  to view this content.

Copy of List of from date and to date for the given number and period 280915.xlsx

Let me know if you have any questions.