Due Date Tracker | Conditional Formatting Using Formula
Channel: DataCense
Date: 2020-10-28

In this video, we will learn about how to create a Due Date Tracker or an Expiry Date Tracker in Excel using Conditional Formatting with Formulas.

Every Day we work Dates. We have to pay our suppliers on a due date or we have to receive money from customers on a certain date based on payment terms. HR department tracks a lot of expiry dates related to Employee Documents like Visa Expiry, Payroll Date, Last working Date etc.

So all these dates need our attention without fail. Conditional formatting will highlight the cell automatically with eye-catching colors and we will be prompted to take some actions.




00:00 Intro
00:52 Formulaes 
01:28 Apply Formula in Conditional Formatting 





Also, check these videos if you want to learn more 

1 Min Excel: If you enjoy short videos check this section 
https://www.youtube.com/playlist?list=PLh9toghm2mYaXDax0HN-Cr4EMjQ31cQSa

Excel: Check this playlist for Excel-related things
https://www.youtube.com/playlist?list=PLh9toghm2mYbPBpxYyfUeW_l3WoNndRGV

Keyboard Shortcuts: Check this section to save some time in everyday excel work
https://www.youtube.com/playlist?list=PLh9toghm2mYbDImYvh3s-t5f-3CsNEJOP

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
https://www.youtube.com/playlist?list=PLh9toghm2mYaet-gozKg2hiyJ5M_Ypn7G

Power Query: Check the Power Query playlist for Data Preparation & its Automation
https://www.youtube.com/playlist?list=PLh9toghm2mYaoWN8xwis8aWlU0lpUUQoy

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
https://www.youtube.com/playlist?list=PLh9toghm2mYZH_Kohxk_-LCdS4UnwpK0o



Please subscribe to our channel and  Follow us on other social media platforms for regular updates :

Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook https://www.facebook.com/datacense
Twitter https://twitter.com/datacense
LinkedIn https://www.linkedin.com/company/datacense
Instagram https://www.instagram.com/datacense32