How to Use Today's Date Dynamically in Spreadsheet Formulas

When using today's date in a formula, how can I get it to update based on the actual date. E.g. I have a column which is today's date, but I want it to show today's actual date based on when I open the sheet, not when I created the formula / the conditions were met for the formula to output. Is there a way to do that?