Forum Discussion
Automatic Updating the Date List based on Today's Date
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 ?
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
=SEQUENCE(EOMONTH($E$2,0)-$E$2+1,,$E$2)and apply proper format to returned spill.
