Listing Dates Between Two Dates

[AlphaBax]

Administration wants to list the actual dates each employee took off during the year. However, the recording system lists only the first date and the number of total vacation hours.

So I need to get from

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]Joe Blow[/TD]
[TD]9/6/17 [/TD]
[TD] 75[/TD]
[/TR]
</tbody>[/TABLE]



to

[TABLE="class: grid, align: left"]
<tbody>[TR]
[TD]Joe Blow[/TD]
[TD]9/6/17[/TD]
[TD]9/7/17[/TD]
[TD]9/8/17 (skip the weekend)[/TD]
[TD]9/10/17[/TD]
[TD]etc[/TD]
[/TR]
</tbody>[/TABLE]



I can convert hours to days and use WORKDAY to tell me the end date, but can I make it list for me all the dates in between?

 

[admiral100]

Hi,

Try this:

D1=B1
E1 =IFERROR(IF(WEEKDAY(D$1+1)<>7,IF(D$1+COLUMN(A$1)>WORKDAY($B$1,QUOTIENT($C$1/24,1)),"",D$1+1),IF(WORKDAY($B$1,QUOTIENT($C$1/24,1))<D$1+COUNT($D$1:D$1),"",D$1+2)),"")



<d$1+count($d$1:d$1),"",d$1+2)),"")
[TABLE="width: 560"]
<tbody>[TR]
[TD="class: xl63, width: 70"][/TD]
[TD="class: xl63, width: 70"]A[/TD]
[TD="class: xl63, width: 70"]B[/TD]
[TD="class: xl63, width: 70"]C[/TD]
[TD="class: xl63, width: 70"]D[/TD]
[TD="class: xl63, width: 70"]E[/TD]
[TD="class: xl63, width: 70"]F[/TD]
[TD="class: xl63, width: 70"]G[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]Joe Blow[/TD]
[TD="class: xl64"]06/09/17[/TD]
[TD="class: xl63"]75[/TD]
[TD="class: xl64"]06/09/17[/TD]
[TD="class: xl64"]07/09/17[/TD]
[TD="class: xl64"]08/09/17[/TD]
[TD="class: xl64"]10/09/17[/TD]
[/TR]
</tbody>[/TABLE]
<d$1+count($d$1:d$1),"",d$1+2)),"")< html=""></d$1+count($d$1:d$1),"",d$1+2)),"")<></d$1+count($d$1:d$1),"",d$1+2)),"")

 

[admiral100]

Please ignore text above the table and below,I do not know how to delete it ...