Calculating how many days to next Friday

Question

Hi all,

I have the dates below:

2023-01-13
2023-01-20
2023-01-27
2023-02-03
2023-02-03
2023-02-03
2023-02-10
2023-09-15
2023-02-03

What i'm trying to figure is how to calculate how many days it is until the next Friday from these dates it should be easy enough but i cant seem to get my head around it.

Cheers for nay help in advance

apathetichell · Answer

fyi - this technically this is "the next friday" - calculating days till "next friday" - ie the next occuring friday after "this friday" would require wrapping @binu_acs 's nifty 5-xxxx statement in a mod(...,5) to correctly skip this friday.

binu_acs · Answer

@Deano478

DateTimeAdd(DateTimeAdd([Date],5-ToNumber(DateTimeFormat([Date],"%w")),"days"),7,'days')

Luke_C · Answer

hi @Deano478

Here's how I'd approach:

* Add 7 to the date
* Generate 1 row for every day between the two
* Add formatting to show day of week (you can collapse this into the filter tool but wanted to show you for clarity)
* Filter on Friday

Friday.yxmd