Return #Days from today based on several conditions.

[Plukey]

I don't have anything close to working yet. My boss needs to know if an item has been in inventory for more than 120 days added to a weekly report. It sounds easy at first, I have to manually accomplish the task and hoping someone has an idea. I'm okay with VBA or Formula or anything that is close that I can work off of. Any thing would be appreciated!


1st. I use dated if formula to count #days between column (AF) & Today then,
2nd. Filter Column (F) with just "N" & Blanks. Column (F) Only contains ( Y, N, Blanks) then,
3rd. Filter Column AH only Blanks. Column (AH) only contains Dates when an item has shipped. then,
4th. I manually enter the total lines that are over 120 days in a cell on our report sheet & copy and paste the list to a summary sheet in the workbook.

 

[maabadi]

Please upload your example file & Desired Results with XL2BB ADDIN (Preferable) OR upload it at free uploading site e.g. www.dropbox.com or googledrive or onedrive and insert link here.

 

[Plukey]

Please upload your example file & Desired Results with XL2BB ADDIN (Preferable) OR upload it at free uploading site e.g. www.dropbox.com or googledrive or onedrive and insert link here.

Unfortunately, where I work I'm prohibited and blocked from sending any information. Thank you anyway for the quick response.

 

[Plukey]

Maybe I can clarify and make it sound a little less confusing..

Count the number of days between TODAY() and Column AF
*****Only if Column (F) = a letter "N" or a Blank Cell & If Column (AG) through (AM) are Blank cells.

that'll get me started.

 

[Plukey]

I guess something like this, I typed up real quick, tested and it gives errors.

=IF(F2="",TODAY()-AF2,IF(F2="*N*",TODAY()-AF2,IF(AG:AM="",TODAY()-AF2)))

 

[Sufiyan97]

Try
Put formula in AB3

=IF(OR(F3="N",F3=""),IF(AND(AG3="",AH3="",AI3="",AJ3="",AK3="",AL3="",AM3=""),TODAY()-AF3,""),"")

 

[Plukey]

Try
Put formula in AB3

=IF(OR(F3="N",F3=""),IF(AND(AG3="",AH3="",AI3="",AJ3="",AK3="",AL3="",AM3=""),TODAY()-AF3,""),"")

Works Perfect!!! Thank You!!!

 

[Sufiyan97]

You're welcome!