Here is how I'm doing it in Excel:
=CEILING(J3-DAY(J3)-5,7)+13
Where J3 is the first day of each month of the year. I can probably figure out how to emulate the J3 calculation in Knack, but how would I go about rounding a date to the next highest multiple of 7?
Any ideas?