The syntax for the TODAY functions is as easy as you can get. There are NO parameters!
=TODAY()
Can’t get easier than that eh?
All you need to do to get this function to work is type the above syntax in a cell of Excel and hit return. The cell will return the current date and then every time the workbook is opened, the cell will update to the current date.