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
Let's say you want to know the number of Fridays until the date in cell A1:
=QUOTIENT(A1-TODAY()+WEEKDAY(TODAY(),15),7)
Let's say you want to know the number of Fridays until the date in cell A1:
=QUOTIENT(A1-TODAY()+WEEKDAY(TODAY(),15),7)
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.