SOLVED

Countdown

Copper Contributor

Hi all. I have a spreadsheet set up and i need a cell to calculate how many Fridays until a date. Is it possible to do this at all please?

 

thank you

3 Replies
best response confirmed by Paskylou (Copper Contributor)
Solution

@Paskylou 

Let's say you want to know the number of Fridays until the date in cell A1:

 

=QUOTIENT(A1-TODAY()+WEEKDAY(TODAY(),15),7)

Youre the best thank you so much

@Paskylou 

The 365 formula is somewhat overkill

= LET(
    today,     TODAY(),
    dateRange, SEQUENCE(1+endDate-today,,today),
    fridays,   FILTER(dateRange, WEEKDAY(dateRange,2)=5),
    COUNT(fridays)
  )

but, one day, the list of Fridays could be useful.

 

1 best response

Accepted Solutions
best response confirmed by Paskylou (Copper Contributor)
Solution

@Paskylou 

Let's say you want to know the number of Fridays until the date in cell A1:

 

=QUOTIENT(A1-TODAY()+WEEKDAY(TODAY(),15),7)

View solution in original post