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

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?

Book1.xlsx

Datasets

Date Time

Accepted answers

DataNath

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:

Month + 15 or month end.yxmd

All comments

binu_acs

@ajohnson211 One way of doing this

Day_130223.yxmd

ShankerV

Hi @ajohnson211

One way of doing this.

Many thanks

Shanker V

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

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

binu_acs

@ajohnson211 Updated the workflow

ajohnson211

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

DataNath

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:

Month + 15 or month end.yxmd

binu_acs

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

Day_130223.yxmd

ajohnson211

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703