Question

difference between today () and date() functions. ​

Answer 1

Answer:

Today :

It displays the current date

Syntax : =TODAY()

Example : =TODAY() gives the output mm/dd/yyyy

Date :

It creates a valid date

Syntax : =DATE()

Example : =DATE(C2,A2,B2)

Hope it helps

Answer 2

As you saw above, the DATEDIF function calculates the difference between a start date and an end date. ... When you use the TODAY() function, Excel uses your computer's current date for the date. Keep in mind this will change when the file is opened again on a futureday