Question

Explain =Date () function in computer

Answer 1

Answer:

The DATE function returns a serial date value.

1. A serial date is how Excel stores dates internally and it represents the number of days since January 1, 1900.
2. If the year is greater than 9999, the DATE function will return the #Num and that was it

Answer 2

The DATE function returns a serial date value.

A serial date is how Excel stores dates internally and it represents the number of days since January 1, 1900.

If the year is greater than 9999, the DATE function will return the #Num and that was it