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)


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



Youre the best thank you so much


The 365 formula is somewhat overkill

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

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