Excel Magic Trick #12: Date Math!
Loading...
Loading...
66,808
Loading...
Uploader Comments (ExcelIsFun)
Video Responses
This video is a response to Excel Trick
see all
All Comments (56)
-
the voice was catchy
-
45 years? You sound as spry as 20 year old!
-
Man my birthday is 11/1/1999 :)
-
No way (alt+F4)
Loading...
4:48
Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functionsby ExcelIsFun48,097 views- 3:12
Excel Magic Trick #14: Amazing Find & Go To Trick!by ExcelIsFun22,717 views
- 5:00
Excel Magic Trick #11: How Good Is Your Average?by ExcelIsFun16,708 views
- 1:43
Excel Magic Trick #20: Lightening Fast Copy Trick!by ExcelIsFun22,048 views
- 7:12
How to Calculate a Future Date in Excel 2003by DannyRocksExcels8,180 views
- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun35,589 views
- 2:54
Excel Magic Trick #92: Two Chart Types In One Chart!by ExcelIsFun21,245 views
- 2:01
Excel - How many days late from the due date ?by ExcelSmart3,682 views
- 5:18
Excel Magic Trick #94: VLOOKUP Into Web Queryby ExcelIsFun12,770 views
- 8:54
How to Use Date Functions in Excelby DannyRocksExcels4,484 views
- 7:58
Excel Lookup Series #1: VLOOKUP Function 1st Exampleby ExcelIsFun315,616 views
- 7:51
Excel Basics #15: Date & Time Format & Calculationsby ExcelIsFun73,389 views
- 9:03
Introduction to Writing Excel Macros (VBA)by jakeblanchard515,719 views
- 4:08
Excel Magic Trick # 10: 3 types of Averages!by ExcelIsFun19,295 views
- 9:41
Excel Basics #22: IF function formula made easy!by ExcelIsFun127,952 views
- 3:30
Excel Magic Trick # 3: AVERAGE & Go To Blanksby ExcelIsFun31,629 views
- 4:19
Microsoft Excel #04: Excel as a Databaseby freetutorials449,471 views
- 2:56
Excel Magic Trick # 9: Join 2 Cells into 1by ExcelIsFun31,742 views
- 7:55
Excel Magic Trick #130: 3 Dimensional Database in Excelby ExcelIsFun23,408 views
- 8:02
Excel Magic Trick #111: Build A Questionnaireby ExcelIsFun25,188 views
I am trying to do conditional formatting on a date. I want to take a date that is in a cell and turn that cell a different color when it reaches 7 days past the date entered. Do you have any videos or helpful hints for that?
psychfanforlife 1 year ago
try this:
Excel Magic Trick # 271: Conditional Format w DATEDIF function
or
Excel Magic Trick 631: Conditional Formatting Invoices 90 Days Past Due
ExcelIsFun 1 year ago
thanks man
epills007 1 year ago
You are welcome!
ExcelIsFun 1 year ago
can i create reports like party wise report, item wise report without use of filter we want dropdown list and enter the out give a page it is possible in excel
waseemakhlaq123 1 year ago
I do not know how to do that. Try this web site for Excel questions:
mrexcel[dot]com/forum
The SMARTEST Excel People In The World Hang Out At This Site!
ExcelIsFun 1 year ago