Inventory expires, Now, 30, 60, 90, 90+ days

Hello all,

1. This is One page of 20 from a workbook that im trying to set up for our Monthly Date checks on items within each Unit.
2. What im trying to do is have the appropriate Cell Marked with a 1 if said Line item has expired, will expire in 30, 60, 90, or > 90 Days of inputted date in Column C Cells
3. Then the information from 4 separate work books will be transferred to a Master Inventory Workbook into the appropriate cells to show how many of what item is/will expire in said days

Given the Jest of what im after and im not sure if a formula or VB code is best way to go. Anyone with a thought, sugestion, or answer please respond i welcome all input


Thank you,
Aeneren

It depends whether you want a 1 to appear in all columns next to an expired item or not?
If not, this could work in Col I =IF(OR(C3<=NOW(),$C3=""),"",IF($C3-NOW()<60,1,""))
Else change it to read =IF(C3="","",IF(C3-NOW()<60,1,""))
For the other columns, merely change the value 60 to 30 or 90.
=IF(C3="","",IF(C3<NOW(),1,"")) will work for the expired column

A slightly different take on it:
In E3 and down: =IF(C3="","",IF(TODAY()>C3,1,""))
In G3 and down: =IF(OR(C3="",E3=1),"",IF(C3-TODAY()<30,1,""))
In I3 and down: =IF(OR(C3="",G3=1),"",IF(C3-TODAY()<60,1,""))
In K3 and down: =IF(OR(C3="",SUM(G3,I3=1)),"",IF(C3-TODAY()<90,1,""))
In M3 and down: =IF(C3="","",IF(C3-TODAY()>90,1,""))

KassieK,

Thank you for your response, Could you use your formulas in the colums that you are sugestiing. ive been trying but havent yet gotten them in place working as i would like.

Cutter, Thank you for your response ill try those out in few.


Thank You
Aeneren

Try this, it shows a 1 only in one column
Outdated in E3 and down
=IF(C3="","",IF(C3<now(),1,""))
<30 Days in G3 and down
=IF(OR($C3<=NOW(),$C3=""),"",IF($C3-NOW()<30,1,""))
<60 Days in I3 and down
=IF(OR($C3<=NOW(),$C3=""),"",IF(AND($C3-NOW()>30,$C3-NOW()<60),1,""))
<90 Days in K3 and down
=IF(OR($C3<=NOW(),$C3=""),"",IF(AND($C3-NOW()>60,$C3-NOW()<90),1,""))
and in >90 Days and down
=IF(OR($C3<=NOW(),$C3=""),"",IF($C3-NOW()>90,1,""))

=IF(OR($C3<=NOW(),$C3=""),"",IF(AND($C3-NOW()>30,$C3-NOW()<60),1,""))
>90 Days in M3 and down

Cutter, thank you for your help with this.

KassieK, Thanks for the quick reply, And you have gotten it, Thank you so much.

Now to build the Master Inventory to open the 4 individual inventory's and pull the data to it.


Thanks Again,
Aeneren