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.
This is a great start! Thank you!
Now, how do I get the output month-day to be the month from the date processed?
ie:
Date Processed:
1/18/2023 11:03:56
Date:
2023-01-18
Output:
January-31
Thank you!!
How do I get the output month-day to be the month from the date processed?
ie:
Date Processed:
1/18/2023 11:03:56
Date:
2023-01-18
Output:
January-31
I appreciate the update, but it won't work for the year. I will eventually have dates for 2023, and I need it to read those and give the correct Month output.
Could you include a file for me to see? I cannot see your other two formulas.