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?
Solved! Go to Solution.
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.
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:
Thank you both! Its working now, I appreciate it!