Forum Discussion
Kenyatta_Harris
Jul 26, 2023Copper Contributor
Formula
If g38 date is between the 1st -15th day of the month, return the month and year of g38
If g38 date is between the 16th - 31st day of the month, return the next month and current year of g38
Example
8/12/2023 return 8/01/2023
8/22/2023 return 9/01/2023