min formula

daveyc18

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

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,764
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
 

Watch MrExcel Video

Forum statistics

Threads
1,089,751
Messages
5,410,218
Members
403,304
Latest member
pajg

This Week's Hot Topics

Top