I'm trying to develop a formula that scans an entire row of dates (Row 2) and determines where "Today" falls into that range. When the value comes back as TRUE, then the corresponding Percentage above (Row 1) is reported in cell B12.
In the attached spreadsheet, since today is 4/22/2015, the value in B12 would be 13.98%. (same would be true if today was 4/20/2015). This would automatically change to 18.21% on 4/27/2015. Thanks in advance.
Try this formula
=INDEX($C$1:$CA$1,MATCH(B11,C$2:CA$2))
format cell as percentage with 2 decimal
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Put in B12:
=INDEX(C1:CA1,MATCH(B11,C2:CA2))
Amazing! Thanks.
As dates are in order.. you can try this too..
Formula:
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks