Wait, what do you mean by (if it falls on a date in the middle of the month) ?
Is that pretty much any Day other than the 1st ?
so if it falls on the 2nd, it should then go to the 1st of the next month?