Forum Discussion

Kenyatta_Harris's avatar
Kenyatta_Harris
Copper Contributor
Jul 26, 2023

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

Resources