Blog of Calc LLC

TODAY function returns the current date. Syntax TODAY() Examples Notes TODAY function is a volatile function. The value it returns is the date when the spreadsheet is recalculated, not the date when the spread is created. Today only returns the current date without a time component. To create a time with date and time, use NOW function.

NOW function returns the current date and time. Syntax Now() Examples Notes NOW is a volatile function. Each time the spreadsheet is recalculated, the result of NOW function will be updated. If you do not need the current time but only current date, use TODAY function instead.