Due Date Tracker | Conditional Formatting Using Formula

Описание: 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
   • Shorts : Random  

Excel: Check this playlist for Excel-related things
   • Excel  

Keyboard Shortcuts: Check this section to save some time in everyday excel work
   • Excel Keyboard Shortcuts  

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
   • Pivot Tables  

Power Query: Check the Power Query playlist for Data Preparation & its Automation
   • Power Query  

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
   • Power BI  



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

Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook   / datacense  
Twitter   / datacense  
LinkedIn   / datacense  
Instagram   / datacense32