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

Leave a Reply

Your email address will not be published. Required fields are marked *