formula for startdate and enddate

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,695
Office Version
  1. 365
Platform
  1. Windows
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>
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

sheetspread

Well-known Member
Joined
Sep 19, 2005
Messages
5,119
Does this work?

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th><th>Z</th><th>AA</th><th>AB</th><th>AC</th><th>AD</th><th>AE</th><th>AF</th><th>AG</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Start</td><td style=";">End</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;">3/14/2018</td><td style="text-align: right;;">4/5/2018</td><td style="text-align: right;;"></td><td style="text-align: right;;">3/14/2018</td><td style="text-align: right;;">3/15/2018</td><td style="text-align: right;;">3/16/2018</td><td style="text-align: right;;">3/19/2018</td><td style="text-align: right;;">3/20/2018</td><td style="text-align: right;;">3/21/2018</td><td style="text-align: right;;">3/22/2018</td><td style="text-align: right;;">3/23/2018</td><td style="text-align: right;;">3/26/2018</td><td style="text-align: right;;">3/27/2018</td><td style="text-align: right;;">3/28/2018</td><td style="text-align: right;;">3/29/2018</td><td style="text-align: right;;">3/30/2018</td><td style="text-align: right;;">4/2/2018</td><td style="text-align: right;;">4/3/2018</td><td style="text-align: right;;">4/4/2018</td><td style="text-align: right;;">4/5/2018</td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;">2/19/2018</td><td style="text-align: right;;">3/30/2018</td><td style="text-align: right;;"></td><td style="text-align: right;;">2/19/2018</td><td style="text-align: right;;">2/20/2018</td><td style="text-align: right;;">2/21/2018</td><td style="text-align: right;;">2/22/2018</td><td style="text-align: right;;">2/23/2018</td><td style="text-align: right;;">2/26/2018</td><td style="text-align: right;;">2/27/2018</td><td style="text-align: right;;">2/28/2018</td><td style="text-align: right;;">3/1/2018</td><td style="text-align: right;;">3/2/2018</td><td style="text-align: right;;">3/5/2018</td><td style="text-align: right;;">3/6/2018</td><td style="text-align: right;;">3/7/2018</td><td style="text-align: right;;">3/8/2018</td><td style="text-align: right;;">3/9/2018</td><td style="text-align: right;;">3/12/2018</td><td style="text-align: right;;">3/13/2018</td><td style="text-align: right;;">3/14/2018</td><td style="text-align: right;;">3/15/2018</td><td style="text-align: right;;">3/16/2018</td><td style="text-align: right;;">3/19/2018</td><td style="text-align: right;;">3/20/2018</td><td style="text-align: right;;">3/21/2018</td><td style="text-align: right;;">3/22/2018</td><td style="text-align: right;;">3/23/2018</td><td style="text-align: right;;">3/26/2018</td><td style="text-align: right;;">3/27/2018</td><td style="text-align: right;;">3/28/2018</td><td style="text-align: right;;">3/29/2018</td><td style="text-align: right;;">3/30/2018</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet4</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D2</th><td style="text-align:left">=A2</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E2</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">D2=$B2,D2=""</font>),"",IF(<font color="Red">WEEKDAY(<font color="Green">D2</font>)=6,D2+3,D2+1</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,129,713
Messages
5,637,936
Members
416,993
Latest member
ant8989

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
Top