Hi Jindon, the cell formatting is correct values are incorrect in the cells and in the formula bar. The data only contains dates for Jan 16 where as the dates displayed for Aug, Oct, Dec months. Where the date is 8th Jan, it's changes to 1st Aug when displayed in Filter sheet. Thanks.