Premium Only Content

How to Calculate Expiry Date and Days Left in Excel / Office Monk
In this video we'll be learning how to use conditional formatting to create expiration alerts in Excel. In order to actually get to the conditional formatting, we'll need to know how to use the IF function, the TODAY function, a simple subtraction. The Today function in excel is going to be necessary in order to figure out which dates are due, or nearing due. =TODAY() in excel is dependent on the computer clock. The =IF() function in excel will figure out, using conditional logic, if we have an expired or non expired invoice. We'll also use a nested if function to add a middle "about to expire" warning. Finally, we'll be using the Text that Contains conditional formatting rule to highlight with different colors the cells that are expired or on time.
#excelformula #exceltip #exceltrick
Please Like, Share and Subscribe: #OfficeMonk
-
LIVE
FreshandFit
11 hours agoHow Difficult Is It For Men In Dating Apps? Girls Find Out...
19,110 watching -
1:57:58
Badlands Media
5 hours agoBaseless Conspiracies Ep. 152
52.7K4 -
2:02:42
Inverted World Live
4 hours agoTrump's Medbeds | Ep. 115
60.2K7 -
2:03:41
TimcastIRL
5 hours agoTrump To Deploy National Guard To Chicago, Federal TAKEOVER Begins | Timcast IRL
199K162 -
2:52:40
PandaSub2000
10 hours agoLIVE 10pm ET | SILENT HILL F w/TinyPandaFace
22.6K1 -
1:26:00
Glenn Greenwald
11 hours agoNick Fuentes On Censorship, Charlie Kirk's Assassination, Trump's Foreign Policy, Israel/Gaza, the Future of the GOP, and More | SYSTEM UPDATE #523
122K327 -
5:49:04
StevieTLIVE
6 hours ago#1 Kar98 Warzone POV Monday MOTIVATION
18.3K1 -
4:45:45
a12cat34dog
6 hours agoTHE *NEW* SILENT HILL :: SILENT HILL f :: IS IT GOOD!? {18+}
16K3 -
1:00:21
Akademiks
4 hours agonba youngboy live show.
47.6K2 -
2:51:15
The Quartering
4 hours agoThey Just Stopped Another Attack, Trump Defeats Youtube, Hasan PIker Meltdown & More
62.1K42