=today()-7
The excel formula above will the date of 1 week ago. It will do this be subtracting seven days from todays date.
The excel formula above will the date of 1 week ago. It will do this be subtracting seven days from todays 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