Automatic Updating the Date List based on Today's Date

[manishb1997]

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 ?

[#2]

@manishb1997 

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

=SEQUENCE(EOMONTH($E$2,0)-$E$2+1,,$E$2)

and apply proper format to returned spill.