min formula

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
387
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
How about
=MIN(INDEX(D5:SJ5,MATCH(A5,D5:SJ5,0)):SJ5)
Where A5 is the cell with your workday formula
 

Forum statistics

Threads
1,078,211
Messages
5,338,888
Members
399,265
Latest member
aj17x55

Some videos you may like

This Week's Hot Topics

Top