Hi -
My apologies if this a repeat of a thread i started earlier, but I don't see it any where in the forum.
I am creating a somewhat dynamic calendar spreadhseet for a user group that has functions that need to be performed on very specific business days (ex. archive data on business day 10). I've got this working. I have the first day of the month in A1 and in column C the business days are populating. (Thank you Excel Forum!)
The group also has some functions that occur on specific days of the month. I would like to populate the 15th of the month or the next business day if it falls on a weekend, and the last day of the month or the previous business day if it falls on a weekend.
Thank you in advance for your help.
Bookmarks