categorize - Microsoft Community

hi guru need input

thanks

enter below formula array formula (ctrl+shift+enter) in cell c2 & copy down - returns values column date in column b = today ie. 2nd august:

=iferror(index($a$2:$a$100,small(if($b$2:$b$100=today(),row($a$2:$a$100)-row($a$2)+1),row(1:1))),"")

enter below formula array formula (ctrl+shift+enter) in cell d2 & copy down - returns values column date in column b after today ie. today plus 1 within 7 days ie. today + 6 days:

=iferror(index($a$2:$a$100,small(if(($b$2:$b$100>today())*($b$2:$b$100<=(today()+6)),row($a$2:$a$100)-row($a$2)+1),row(1:1))),"")

you may update "$b$2:$b$100>today()" , "$b$2:$b$100<=(today()+6)" indicate after today , before today plus 6 days, per requirement.

note: first formula returns per today's date 2nd august. 2nd formula returns corresponding values 3rd august till 8th august. explained, these dates can updated.

regards,

amit tandon

www.globaliconnect.com

Office / Excel / Windows 10 / Office 2010