Let’s add an input value to make it more flexible. By referencing an input cell (B1), you can automatically change the number of values SEQUENCE () returns, as shown in Figure B. Simply change ...

Fortunately, Excel’s TODAY () function always equals the current date, so you don’t have to update the rule or even include an input value. SEE: Explore these 87 Excel tips every user should ...