TODAY

Definition of TODAY

Returns the current date as a date value.

Syntax

TODAY()

Notes

• Note that TODAY is a volatile function and can hurt spreadsheet performance.
• TODAY provides the current date with no time component. To create a date with the current time, use NOW.
• TODAY will always represent the current date the last time the spreadsheet was recalculated, rather than remaining at the date when it was first entered.

See Also

NOW: Returns the current date and time as a date value.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

In order to use the TODAY formula, start with your edited Excellentable

Then type in the TODAY Formula in the area you would like to display the outcome:

By adding the values you would like to calculate, Excellentable generates the outcome:

	A	B	C	D
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2	House seat(s)
2	Alabama	4833722	52,420 (135,767)	50,645 (131,170)
3	Alaska	735132	665,384 (1,723,337)	570,641 (1,477,950)
4	Arizona	6626624	113,990 (295,233)	113,594 (294,207)
5	Arkansas	2959373	53,179 (137,733)	52,035 (134,770)
6	California	38332521	163,695 (423,968)	155,779 (403,466)
7	Colorado	5268367	104,094 (269,602)	103,642 (268,432)
8	Connecticut	3596080	5,543 (14,356)	4,842 (12,541)
9	Delaware	925749	2,489 (6,446)	1,949 (5,048)
10	Florida	19552860	65,758 (170,312)	53,625 (138,888)
11	Georgia	9992167	59,425 (153,910)	57,513 (148,958)
12	Hawaii	1404054	10,932 (28,314)	6,423 (16,635)
13	Idaho	1612136	83,569 (216,443)	82,643 (214,044)
14

	E	F	G
1

Date

TODAY