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
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
- Defcon dates - Guide
- How to highlight overdue dates in excel ✓ - Excel Forum
- Encryption And Decryption - Download - Encryption and decryption
- Vivatech 2024 dates - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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