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.

     

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    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)

Resources