If a date falls between 2 set dates, return a specific date.

[ajohnson211]

I have a column with dates (currently a string but I can easily change to date/time). If the dates are between the 1st-15th of any given month, I want it to return "month-15"

If the same column of dates is between the 16th-end of the month I want it to return the "month-last day of the month"

Would someone be able to help me with that?

[ajohnson211]

Thanks. 
It isn't showing your formulas. I am only seeing the New Date formula. Which unfortunately doesn't solve my question about getting the correlated month - 15th or last day of the month.

[DataNath · Accepted solution]

Hey @ajohnson211, are you looking for something like this? I've appended an additional 4 records to the bottom of the dataset to show this working with a few more months/days:

[binuacs]

@ajohnson211 sorry,  uploaded the wrong workflow. attaching the correct one

[ajohnson211]

Thank you both! Its working now, I appreciate it!