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   ...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Jul 26, 2023

Kenyatta_Harris 

 

=DATE(YEAR(G38), MONTH(G38)+(DAY(G38)>15), 1)

 

or

 

=EOMONTH(G38, -(DAY(G38)<16))+1