Expirations dates in a worksheet-HELP!

[swan08]

I have a worksheet with a column of expriation dates mm/dd/yy. Once a month I need to found the ones that are expired for the current month. Can I set up a macro for excel to show ONLY the expriations dates that are expired or that will expire the next month.Kind of like a reminder or tickler.

I hope I made this clear enough.

 

[JimM]

Hi

Simplest thing would be to use the

Autofilter > Custom options to show only the dates you want eg only those less than 01/07/08 etc

 

[Jonmo1]

Welcome to the board...
You can use Conditional Formatting for that...

Highlight your ranbge of expiration dates
Click Format - Conditional Formatting
Select "Value Is"
Select "Less than or Equal To"
enter =TODAY()
Click Format
Click Patterns
Select A Color to highlight the expired cells with
Click OK
Click OK

This is assuming no BLANKS in the Expiration Date Column. Blanks will get highlighted...That can be resolved if it's a problem for you...

Hope this helps..

 

[swan08]

Thanks! Does the date have to be in a particular format? I tried another spreadsheet and the date was formatted 12-Jan-90 and it doesn't seem to work.

 

[Jonmo1]

That probably means they aren't Valid Excel Dates.

To test that, put this formula anywhere
=ISNUMBER(A1)
where A1 is a date
if it returns false, it's not actually a valid date, just a text string that looks like a date