Question
July 12, 2022 Would it be possible to make a formula that divides the year into 24 2 week pay periods and shows the current pay period (2 week period for a paycheck) every pay period is 1 - 15, 16 - 30 (or 16 - 31 if there's 31 days) Like a if today is Jan 1 - 15, Period 1, if today is Jan 16 - 30, Period 2
The solution below is made with the replacement formulas generator (available for free in English and French).
replaceAll("◙◙032Period 6◙031Period 5◙022Period 4◙061Period 11◙021Period 3◙052Period 10◙011Period 1◙051Period 9◙042Period 8◙041Period 7◙012Period 2◙062Period 12◙071Period 13◙072Period 14◙081Period 15◙082Period 16◙092Period 17◙091Period 18◙101Period 19◙102Period 20◙111Period 21◙112Period 22◙122Period 24◙121Period 23◙", concat("◙[^◙]*(?:[^◙]*?◙", format(formatDate(prop("Date"), "MM") + if(date(prop("Date")) < 16, "1", "2")), ")*"), "")