How To Identify Or Highlight Upcoming Expiration Dates In Excel

Now its always better to know your products expiration date beforehand. This is why in this advanced excel tutorial we will learn how you can identify expiration dates before 90 days. That means you can now find out products that has expiration dates within the next 90 days. Now that we identified it you con focus on those product's sale. No more wasted products. By the way you can identify upcoming expired dates before 90 days or before your proffered time frame. No issues. Lets learn how to identify or setup a 90 days warning before product expire date.

Step 1: Select the data range where you have written expire date
Step 2: Click on the conditional formatting
Step 3: Click on new rules and then select "Use a formula to determine which cells to format"
Step 4: Write the formula in the formula bar (Formula is in the comment section)
Step 5: Click on format and select the color that you want to highlight with.
Step 6: Click Ok twice and done.

Now you have highlighted products that have expire date within next 90 days.

#Highlight #ExpiredDate
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[pianosisters]

suppose if we want highlight the next call date to follow up . Example. If we call today and keep the next call date for 21st Sep and would like to Highlight. How do we do it Sir. Please explain

[mrbumble]

Is there any way of creating a kind of separate "summary" sheet to show lets say expired and expiring in <3 days? I have conditional formatting for my big data sets which works great but what if I just wanted a quick view of the expired and expiring soon items on a separate sheet which auto-populates. Is it possible?

[alanwebb]

How do I stop a cell that doesn't have a date from defaulting to my expired date format?

[jiinda]

HI SIR, I'm all following by the formula from you, but it doesn't work on my MacBook and I dun know why?

[nickdorfnus]

mine highlights everything, even if its out of the range. Confused as to why. Followed all steps. I have text selected as date, I believe thats correct.

[alejandroquintero]

How would I track from a specific day rather than “today”

[erikvanelst]

Trying to fill in the formula. Copy-paste it, but Excel says: the formula contains an error. Can anyone help?

[ebshuler]

I put in that formula and nothing happened, do the dates have to be put a certain way?

[saadbinhasan]

What if we want to do it for multiple columns

[life-ocjt]

Please explain that formula, its quit complicated

[CGAZ]

There is a easier way go to highlight cell rules instead

[shorts]

Where is the formula dude? I can't find

[Exceltutorial]

=AND($B2>TODAY(), $B2-TODAY()<=90)

[GouravKumar-hrvd]

Not working in excel 2016, need urgent help