Forum Discussion
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
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)
Youre the best thank you so much