Hello,
I am trying to find the formula that I would need to input a value if the date is the 15th business day of the month (so if 15th is Saturday, Monday's date would be where I want the value inserted)
Ex: Cell A1 is the date in cell B1 if that date in A1 is the 15th (or closest business day) insert 21, if it is not 0
Thank you for helping!
Bookmarks