Automatic Updating the Date List based on Today's Date

Copper Contributor

I want to make a list where the previous date will be removed and only today's date and upcoming dates will be there. I have done something like below in image. Is there any effective way to do so ?Screenshot (64).png

1 Reply


Since your tag is Excel for web I assume you are on Excel 365. In it the list, as variant, could be created as


and apply proper format to returned spill.