Update Selling Days Used based on date chart

[warhammer486]

I'm trying to figure out how to get cell P4 (Selling Days Used) to automatically change its value based on the current day and the chart set up on the left. So if it is February 26, I'd like P4 to change automatically (with a formula or pushing a button that triggers a macro) to show the current day's value of 21. I currently am manually updating it each day referring to the chart.



Thank you.

 

[RasGhul]

maybe this, adjust the ranges to suit your data;

Just to confirm that 22 correlates to 26th Feb?

=INDEX($M$2:$M$23,MATCH(TODAY(),$L$2:$L$23,0))

 

[warhammer486]

maybe this, adjust the ranges to suit your data;

Just to confirm that 22 correlates to 26th Feb?

=INDEX($M$2:$M$23,MATCH(TODAY(),$L$2:$L$23,0))

Thank you for your help. That appears to be what I was looking for. Index and Match always confuse me.