Yes, you can use the current date in a formula to create a rolling date. You can use the moment() function to get the current date and time. For example, you can use moment().format("MMMM, D YYYY") in your formula to dynamically populate the current day's date.
To create a rolling date, you can use the AI formula generator to help you construct more complex formulas. For instance, you could create a formula that calculates the number of days between the current date and another date column in your table.
If you need further assistance with creating specific rolling date formulas, feel free to ask for more details.