Calculate specific day before and next day

[OscarCuevas]

Can you help me? please

How can I calculate the previous Thursday and next Wednesday of the column Dateline?

Regards!

Dateline	Review day  (previous thursday)	Payment day (next wednesday)
04/02/2021
13/02/2021
01/03/2021
07/03/2021
26/02/2021

[Luke_C · Accepted solution]

Hi @OscarCuevas 

See attached sample:

1. I use a generate rows tool to create rows for 7 days before and after each date
2. Dates are filtered to the previous thursday and next wednesday
3. I re-format the dates to the dd/mm/yyyy format
4. Crosstab is used to get the dates into columns

Let me know if this works for you