Countdown

[Paskylou]

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

[#2 · Accepted 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)

[#3]

Youre the best thank you so much

[#4]

@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.