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
Russell Brand
1 hour agoKamala’s CAR CRASH ‘The View’ Interview + DeSantis EXPOSES Harris Hurricane LIES – SF470
11,201 watching -
LIVE
Grant Stinchfield
12 minutes agoSwing State Non-Citizens Caught on Tape Registering to Vote! (NC, AZ, GA)
1,379 watching -
LIVE
WeatherNation
2 days agoWeatherNation Live 24/7
2,170 watching -
LIVE
The Dilley Show
45 minutes agoTrump En Fuego! Kamala Sinking and 27 Days! w/Author Brenden Dilley 10/09/2024
3,175 watching -
UPCOMING
themidwesterner
5 minutes ago'Abandon Harris' group press conference with Jill Stein in Dearborn, MI
-
LIVE
Tudor Dixon
59 minutes agoHurricane Helene - The Aftermath | The Tudor Dixon Podcast
344 watching -
LIVE
The Shannon Joy Show
4 hours ago🔥🔥SHOCK STUDY - America Has Been In A Deep Recession For FOUR YEARS! Live W/ Economist Jeffrey Tucker - Brownstone Institute Report Analysis TODAY🔥🔥
313 watching -
1:01:47
The Dan Bongino Show
3 hours agoKamala Harris Says The Worst Thing Possible (Ep. 2346) - 10/09/2024
189K1.48K -
3:32
BuddyBrown
1 year ago"Republican Neighbors" | Buddy Brown | Truck Sessions
3.81K12 -
1:15:54
Steven Crowder
3 hours agoKamala’s Media Blitz Ends in Disaster & Major Swing State Polling Update
135K354