#1
|
|||
|
|||
find who less than one year
hello everyone. I want fix this formula to find who less Days 365 (less than one year) from list in table K5 =IFERROR(INDEX($B$6:$B$2220;SMALL(IF(YEAR($N$2)=YE AR($J$6:$J$2220)*(MONTH($N$2)=MONTH($J$6:$J$2220)) ;ROW(B$6:B$2220)-5;"");ROW()-5));"") all help will be appreciated Thank you |
#2
|
|||
|
|||
Would it be easiest enough to just use conditional formatting in K5 to identify anything less than 365 days?
Conditional Formatting
|
#3
|
|||
|
|||
Thank you so much jeffreybrown
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to search for a specific year from a table with year range? | Wii | Excel | 0 | 05-05-2015 12:40 PM |
How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
Networkdays per fiscal year in a 6 year range | jabnm | Excel | 1 | 10-16-2014 11:51 AM |
Year to Year in Fillable form | Lara | Word | 1 | 04-09-2013 03:19 PM |
Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |