Question: what is the difference between functions today() and now()?
Answer: The TODAY Function will return the current date, while the NOW Function will return the current date and time. These can be very useful for a spreadsheet that requires having the current date and/or time. These functions are a bit different than most other Excel Functions in two ways. They are what's known as volatile.