Can I set up a sheet for reagents that will flag expiry dates?

H

haem

I would like to set up a spreadsheet for reagents that will automatically
flag if a reagent is past its expiry date
 
B

Bernard Liengme

Starting in A1 I have
Reagent Stock date Shelf life Flag
AgNO3 1-Jun-08 270 Out of date


The formula in D2 is =IF(B2+C2>TODAY(),"","Out of date")
Additionally (or as an alternative) sue conditional formatting to make the
row red
Select A2:D2 ( when you have more select A2:D(last row)
In Conditional Formatting use:
Formula Is : =$B2+$C2<TODAY() and set format to suit your need

best wishes
PS I have no idea how long a solution of silver nitrate would last, even
thought I was a chem prof!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email notifications without opening application 1
Case statements, too many possiblies, report coding 3
Extract data in rows (with line breaks) to form a table 0
Publisher is filling blank lines with data 2
Lock sets of cells in a row and sort by date linked to each set 0
please suggest a formula 2
Select data for report based on form 0
Can i get the Email 0

Top