Create Date Range from raw dates

Question

Hi Community,

I am looking to create a new column that will have a date range from a list of raw dates. I want the date range to start on a Monday and end on a Sunday.

For example, if the date in a column is showing 2023-01-16, I would like a new column next to this that shows the range 2023-01-16 - 2023-01-22.

Would appreciate any help.

SPetrie · Answer

This is a guess based on what you have shown. I wasnt sure if all dates would be uniform or mixed, but this would work in either situation.

dynamic ranges.yxmd

Prometheus · Answer

@kianhozz As @SPetrie stated earlier, if you would upload some dummy data and give us an example of your expected output, it would be much easier to provide a solution. Thanks.

kianhozz · Answer

I.e, on rows 5 & 6, I would like a new column that simply lists 2023-01-09 - 2023-01-15 (As the 11th is a Wednesday).