Expiration Dates

Hi, thank you very much for your help.

 

I have in about 30 worksheets in 1 workbook. In each worksheet-cell B3, I have expiration dates for materials. I want to create a separate worksheet, lets say worksheet called “About to Expire”, look up all 30 worksheets cell B3, list all the expiration dates that are about to expire within 1 month, or already expired in “About to Expire” worksheet. Also spits out which worksheet that expiration date is coming from. 

 

I have initially tried the formula:

=IFERROR(VLOOKUP(    TODAY()+30, Worksheet1:Worksheet30, 2, FALSE ),”error”) but this failed.

 

I think Vlookup to look up date format is incompatible.. I tried vlookup formula to search the same page but it gives invalid for dates, but it works for words. 

 

Thank you in advance for your help. 

 

Sincerely,

Philip Kim

By: Philip Kim

3 thoughts on “Expiration Dates

  1. Frank

    I have to thank you for the efforts you have put in writing this blog.
    I really hope to see the same high-grade content from you later on as well.
    In fact, your creative writing abilities has
    inspired me to get my very own blog now 😉

  2. Micah Ranaudo

    I discovered your blog web site on google and examine a number of of your early posts. Proceed to maintain up the superb operate. I just extra up your RSS feed to my MSN News Reader. Searching for forward to reading more from you in a while!…

Comments are closed.