Forum Discussion
R_Caron418
Nov 20, 2023Copper Contributor
Ways to count from a select date including weekends but have it output only on the closest weekday
I'm trying to take a select date and add a certain number of days to it and output the new date but the output date must be a weekday. I am trying to use an if statement with nested weekday and workd...
- Nov 21, 2023
R_Caron418 See the attached workbook, especially the notes on the _Info worksheet.
(Note that the column headings for columns E through I are derived from the formulas directly below them.)
SnowMan55
Nov 21, 2023Bronze Contributor
R_Caron418 See the attached workbook, especially the notes on the _Info worksheet.
(Note that the column headings for columns E through I are derived from the formulas directly below them.)
R_Caron418
Nov 21, 2023Copper Contributor
This is perfect. Problem Solved!