formula for startdate and enddate

[lezawang]

I am trying to understand what the user wants but could not. any help would be appreciated

"I am actually looking for a formula for excel, we have a list of new hire students and we have a start and end date on the top of our excel form and below we have an attendance table with 40 columns for 40 days and the trainers have to manually type the first date and then drag the date until they reach the end day of training which can be 40 or less days. I wanted to find a formula that will auto fill the column dates based on the start and end date. If I increment by 1 I will have 40 days and I do not always want it to show 40 days only days up to the end date. Can you help? I forgot to mention that the dates need to be mon-fri only"<ytd-comment-action-buttons-renderer id="action-buttons" class="style-scope ytd-comment-renderer" action-buttons-style="desktop-toolbar" style="display: block; color: var(--yt-button-text-color); min-height: 16px; margin-top: 4px;">
</ytd-comment-action-buttons-renderer>
<ytd-menu-renderer class="style-scope ytd-comment-renderer" style="display: flex; flex-direction: row;"></ytd-menu-renderer>

 

[sheetspread]

Does this work?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	Start	End
2	3/14/2018	4/5/2018		3/14/2018	3/15/2018	3/16/2018	3/19/2018	3/20/2018	3/21/2018	3/22/2018	3/23/2018	3/26/2018	3/27/2018	3/28/2018	3/29/2018	3/30/2018	4/2/2018	4/3/2018	4/4/2018	4/5/2018
3	2/19/2018	3/30/2018		2/19/2018	2/20/2018	2/21/2018	2/22/2018	2/23/2018	2/26/2018	2/27/2018	2/28/2018	3/1/2018	3/2/2018	3/5/2018	3/6/2018	3/7/2018	3/8/2018	3/9/2018	3/12/2018	3/13/2018	3/14/2018	3/15/2018	3/16/2018	3/19/2018	3/20/2018	3/21/2018	3/22/2018	3/23/2018	3/26/2018	3/27/2018	3/28/2018	3/29/2018	3/30/2018
Sheet4

Cell Formulas
Range	Formula
D2	=A2
E2	=IF(OR(D2=$B2,D2=""),"",IF(WEEKDAY(D2)=6,D2+3,D2+1))