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?

[binu_acs]

@ajohnson211 One way of doing this

[ShankerV]

Hi @ajohnson211 

One way of doing this.

Many thanks

Shanker V

[ajohnson211]

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

[ajohnson211]

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

[ShankerV]

Hi @ajohnson211 

Please find the expected result.

Many thanks

Shanker V

[binu_acs]

@ajohnson211 Updated the workflow

[ajohnson211]

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.

[ajohnson211]

Could you include a file for me to see? I cannot see your other two formulas.

[binu_acs]

attaching the workflow