I have a macro that uses "Date" and "Now()" to evaluate date columns in the data. For example, if the date in the row is today, the macro colors that date cell blue. What I would like is to have the code change the cell to blue if the date is tomorrow (instead of today). There are enough instances where I thought rather than re-writing all the code, I could just change "Date" to "Date plus one workday" and "Now()" to either "Now() plus one workday" or use "Date plus one workday" instead.
Looks like "Date + 1" would certainly increment the date the code is working from but I can't find a good example on google of the syntax for a "Date + 1 networkday"
Also was wondering if I could just specify "date=date+1 networkday" at the begining so I wouldn't have to change all the instances of "Date".
Thanks in advance,