Forum Discussion

abhinavkakku's avatar
abhinavkakku
Copper Contributor
Dec 12, 2018

Excel Date Filter Today and Last N Days

I HAVE DATA in a following format
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10
12/11/2018 16:10



and I want to filter it for TODAY - LAST 7 or 5 or N Days Excluding Today , That is if today is 12 Dec I want filter for 12 Dec and December[ 11,10,9,8,7,6,5] for last & days.
How to create custom filter for this in MS Excel

No RepliesBe the first to reply

Resources