I'm working with an excel spreadsheet which has dates. I want to be able to change the dates to the next business date if the date should fall on a weekend or holiday. I found a couple of scripts but they do not tell me how to submit the script into the VB of an excel spreadsheet. I also need the dates to stay in text format.
Any help would be much appreciated.
Q
Any help would be much appreciated.
Q