I would like a small improvement to the WORKDAY function.
For the third argument, we can pass in a range of dates. I want to pass in 0 or false or some other flag to IGNORE working days.
=WORKDAY( {date cell} , 15 , 0 )
would return the date 15 days from now, regardless of project or global settings for non-working days.
I could, of course, use
{ date cell} + some number
but as this thread shows
https://community.smartsheet.com/discussion/need-how-if-blank-addends-blank-if-values-sum
that can be prone to error.
If WORKDAY is not the correct place for it (and it likely isn't), what I am looking for the reverse of the NETDAYS function. That function takes two dates and returns the days in between. I want to give a date and the increment and return the date.
Craig