formula for startdate and enddate

lezawang

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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Does this work?


Excel 2010
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1StartEnd
23/14/20184/5/20183/14/20183/15/20183/16/20183/19/20183/20/20183/21/20183/22/20183/23/20183/26/20183/27/20183/28/20183/29/20183/30/20184/2/20184/3/20184/4/20184/5/2018
32/19/20183/30/20182/19/20182/20/20182/21/20182/22/20182/23/20182/26/20182/27/20182/28/20183/1/20183/2/20183/5/20183/6/20183/7/20183/8/20183/9/20183/12/20183/13/20183/14/20183/15/20183/16/20183/19/20183/20/20183/21/20183/22/20183/23/20183/26/20183/27/20183/28/20183/29/20183/30/2018
Sheet4
Cell Formulas
RangeFormula
D2=A2
E2=IF(OR(D2=$B2,D2=""),"",IF(WEEKDAY(D2)=6,D2+3,D2+1))
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

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
Back
Top