Forum Discussion
EXCEL Deadline-tracker: Counting/ displaying weeks until you reach an event
Hi Community, I want to display the number of weeks it takes until an event is happening for a certain Item (B4, B5, etc.). My timeline is in weeks on the x-axis increasing to the right. There are e...
=IFNA(FLOOR(INDEX($F$4:$V$4,MATCH(C$4,$F5:$V5,0))-TODAY(),7)/7,"")
This formula with INDEX and MATCH could be an alternative. The formula is in cell C4 and filled across range C4:D5.