IF Year(data Loaded)=Year(Today())-1 and month(dataloaded)=Month(Today()) Then True else false end.
Won't this work?
Thank you for replying. This formula doesn't help. If I add this my worksheet becomes blank.
Put This in Rows
IF MONTH([Dataloaded]) = MONTH(TODAY())
AND DAY([Dataloaded]) <= DAY(TODAY())
Drag Year (dataloaded) to Columns and Filter for 2017 and 2016 only.
it doesn't work!