Recalculation of dates
Solved/Closed
BlairBiss
Posts
3
Registration date
Tuesday December 4, 2018
Status
Member
Last seen
December 4, 2018
-
Dec 4, 2018 at 11:04 AM
BlairBiss Posts 3 Registration date Tuesday December 4, 2018 Status Member Last seen December 4, 2018 - Dec 4, 2018 at 12:35 PM
BlairBiss Posts 3 Registration date Tuesday December 4, 2018 Status Member Last seen December 4, 2018 - Dec 4, 2018 at 12:35 PM
Related:
- Recalculation of dates
- If statement with dates - Guide
- How to format dates in excel - Guide
- Numbers, text, dates, or times of day that you type into a cell. ✓ - Excel Forum
- How to add slashes to dates in excel ✓ - Office Software Forum
- Change file dates - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Dec 4, 2018 at 11:43 AM
Dec 4, 2018 at 11:43 AM
Hi Blair,
You are looking for the WORKDAY.INTL function.
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Formula for A41:
=WORKDAY.INTL(A42,-1,1,$B$1:$B$20)
start_date: take the date from A42.
days: subtract 1 day
[weekend]: the 1 here means weekend is Saturday and Sunday.
[holidays]: This is the range where you have listed the holidays. Adjust the range to match yours.
Drag formula up.
Best regards,
Trowa
You are looking for the WORKDAY.INTL function.
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Formula for A41:
=WORKDAY.INTL(A42,-1,1,$B$1:$B$20)
start_date: take the date from A42.
days: subtract 1 day
[weekend]: the 1 here means weekend is Saturday and Sunday.
[holidays]: This is the range where you have listed the holidays. Adjust the range to match yours.
Drag formula up.
Best regards,
Trowa
Dec 4, 2018 at 11:45 AM
Dec 4, 2018 at 11:51 AM
Dec 4, 2018 at 12:35 PM