Hey Adam,
Denis is spot on, create a date for the first of the month, add a month, subtract a day. See the bellow example which uses Today() to just calculate for the current month (replace Today() with any date in your target month)
AddDays(AddMonth...
