min formula

[daveyc18]

i have a formula "=MIN(D5:SJ5)" but D5 starts at 11/02/17.

Now I gotta change it to 11/01/18 since it's a new fiscal year for us....is there a way to make this dynamic? that is, make it such that I dont have to manually look for where 11/01/18 (which is currently cell IS5) and change the formula to "=MIN(IS5:SJ5)"


thanks to an answer in my other post, i am able to find the first day of november of last year's fiscsal year based on this formula: =WORKDAY(DATE(YEAR(TODAY())-1,MONTH(TODAY()),1)-1,1)

 

[Fluff]

How about
=MIN(INDEX(D5:SJ5,MATCH(A5,D5:SJ5,0)):SJ5)
Where A5 is the cell with your workday formula

 

[daveyc18]

How about
=MIN(INDEX(D5:SJ5,MATCH(A5,D5:SJ5,0)):SJ5)
Where A5 is the cell with your workday formula

nvm