Formula for Every Seven Days From Date Passed

Question

Hello Community,

I hope everyone is well.

I have a year's worth of data that I need to formulate a return of every seven days from an specific day in the past.

I am trying the formula below, but it is not working...there are no errors, but it is not separating as expected.

DATETIMEPARSE([captured_date], "%Y-%m-%d") >= DATETIMEADD(DATETIMENOW(), -7, "days")

Thank you,

Fausto

Every 7 Days from Date Passed.xlsx

Fescobar · Answer

Thank you for replying .@luke_c!

The file has a few highlighted cells on the date column.  Those days are all Thursdays going back one year to date (I attached a small sample), these are the dates that I would need returned.

I hope that this clears it up.

Thanks again!

Fausto

mattnason1 · Answer

If you're looking for every 7th day then might be as simple as filtering:

DateTimeFormat([captured_date],"%A") = DateTimeFormat(DateTimeNow(),"%A")

So if captured date was a Wednesday it would grab every Wednesday which would get every 7th day.

Luke_C · Answer

Hi @Fescobar

The formula that you have there will return true or false. What exactly are you looking to do? It's not clear to me based on the attachment. If you provide some more info on inputs and expected output I'm sure there's a solution.