smozgur
BatCoder
- Joined
- Feb 28, 2002
- Messages
- 2,673
YESTERDAY function returns the serial number of yesterday's date.
Excel Formula:
=LAMBDA(TODAY() - 1)
Sample.xlsx | |||
---|---|---|---|
A | |||
1 | Tuesday, December 8, 2020 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | A1 | =YESTERDAY() |
Upvote
0