We're looking for a formula to count the number of times at date is either the 15th or the 28th between two dates in excel.
The goal of the field is to show the number of Semi Monthly Checks in a date range.
For example: from 1/1/2017 - 3/3/2017, there are 4 Semi-Monthly Checks.
Semi Monthly means they get paid twice a month. Usually the 15th and end of month.
I don't know much about VBA or Excel formulas.
Can anyone assist?
Thanks!
Bookmarks