The TODAY function
Returns today's date. It updates every time the sheet recalculates.
Syntax
TODAY()Examples
B1=ISNUMBER(TODAY())
| A | B | |
|---|---|---|
| 1 | TRUE |
B1=IF(TODAY()>DATE(2020,1,1),"After 2020","Before")
| A | B | |
|---|---|---|
| 1 | After 2020 |
Returns today's date. It updates every time the sheet recalculates.
TODAY()| A | B | |
|---|---|---|
| 1 | TRUE |
| A | B | |
|---|---|---|
| 1 | After 2020 |