Formula

[spencertony91]

Good evening. I am looking for some help putting together a formula. I would like to look at a date field and say if that data falls within the first week of that month then my date should equal the first of that month, if it is after the first week then set date to the first of the next month. Any ideas are greatly appreciated. 

[echuong1 · Accepted solution]

Try this:

I used a conditional statement to see if the date value is greater than or equal to the 7th day of the month. If it was, I added 1 month to the first of the month. If it wasn't, I set the value to the first of the month.

[spencertony91]

This was exactly what I needed. Thank you so much for the help. 😁