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
Game On!
17 hours agoIt's A FOOTBALL Friday! NFL In Brazil! Chiefs vs Chargers Preview!
9,934 watching -
14:31
Adam Does Movies
12 hours ago $1.41 earnedAlien: Earth Episode 5 - Recrap
20.7K2 -
12:54
Michael Button
16 hours ago $0.63 earnedWhat If We’re Just the Most Recent Civilization?
1.78K6 -
25:26
World2Briggs
18 hours ago $0.63 earnedTop 15 Most Visited Cities in the World
3.88K1 -
LIVE
BEK TV
22 hours agoTrent Loos in the Morning - 9/05/2025
265 watching -
LIVE
The Bubba Army
21 hours agoTyson vs Mayweather SUPERFIGHT! - Bubba the Love Sponge® Show | 9/05/25
3,472 watching -
LIVE
FyrBorne
1 hour ago🔴Warzone M&K Sniping: This May Be The Most Broken Update Yet
67 watching -
10:59
Degenerate Jay
15 hours ago $1.45 earned007 First Light Is The James Bond Game Fans Deserve
19K2 -
9:11
Faith Frontline
14 hours agoTucker Carlson SHOCKED As Cliffe Knechtle Reveals God’s Chosen People
6.81K4 -
23:10
Jasmin Laine
16 hours agoCTV Host Visibly UNCOMFORTABLE As Guest Calls Canadians RACIST—Poilievre Leaves Them SPEECHLESS
12K5