=today()-1
The formula above will give you yesterday's date. It does this by subtracting one day from today's date.
The formula above will give you yesterday's date. It does this by subtracting one day from today's date.
Sunday, October 28, 2012
Subscribe to:
Post Comments (Atom)
www.cineclouds.com. Powered by Blogger.
Popular Posts
Blog Archive
-
▼
2012
(38)
-
▼
October
(22)
- Using Weekday function in Excel
- Using Tomorrow date function in Excel
- Year function
- Month function in Excel
- Using Addition in Excel
- Yesterday's Date Function in Excel
- One week ago date function in Excel
- Current Date Function in Excel
- Absolute formula in Excel
- Division
- Multiplication in Excel
- Using Subtraction in MS Excel
- Date and Time function in Excel
- Using IF Statements in MS Excel
- IF Search Statement (wildcard if statement)
- IF Statements...continued
- Using IF Statements in MS Excel
- Using Minimum Formula ub Excel
- Using VLOOKUP Exact Match Formula in Excel
- Using Maximum formula in Excel
- Using CountIF Formula in Excel
- Using Sum Formula in Excel
-
▼
October
(22)
0 comments:
Post a Comment