Forum Discussion

Paskylou's avatar
Paskylou
Copper Contributor
Oct 16, 2023
Solved

Countdown

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
excel
Formulas and Functions
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Oct 16, 2023

    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)

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Oct 16, 2023

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.

 

Resources