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
-
57:58
The Rubin Report
2 hours agoDebate over COVID Failures Gets Tense | Chris Cuomo
27.5K28 -
2:06:37
Steven Crowder
3 hours agoREBUTTAL: Jon Stewart is WRONG about Gun Violence
120K193 -
2:10:55
Matt Kohrs
3 hours agoStocks Are EXPLODING HIGHER, Nvidia is King & GameStop is Falling
29K6 -
1:28:50
Graham Allen
4 hours agoMega Church Pastor Forced to RESIGN! + Ten Commandments Back in Schools🔥
47.6K95 -
44:57
Rethinking the Dollar
2 hours agoGOP WANTS $500 BILL TO HONOR TRUMP | SIGNS OF GREATER INFLATION TO COME? | Morning Check-In w/ Mike
17.9K4 -
1:36:11
The Podcast of the Lotus Eaters
7 hours agoThe Podcast of the Lotus Eaters #941
56.9K33 -
1:17:47
jeffahern
4 hours agoThursday Thrash With Jeff Ahern (6am Pacific)
23K3 -
2:05:19
AP4Liberty
5 hours agoBorder Wars Breakout Between Kansas and Missouri... Again!
26.4K4 -
19:28
Stephen Gardner
10 hours ago🔴BREAKING: Biden’s RECKLESS new scheme fails with the PEOPLE!!
45.8K61 -
1:03:16
Kimberly Guilfoyle
3 days agoSlow Joe Hits a New Low, Plus New Case of Illegal Immigrant Crime, Live with Karoline Leavitt & Sen Tommy Tuberville | Ep. 134
103K92