Expire dates

[MohdTareq007]

Hallo.,

Is it possible to get a formula in cell e1 while analyzing Expiring dates cell a1 date1, b1 date2, c1 date 3, if any of these cells dates are expired or expiring soon (less than 30 days)

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[MohdTareq007]

Hi I would like to add if function for detecting soon Expiring on the below formulas if min
=IF(MIN(K8:M8)=0,"",IF(MIN(K8:M8)<TODAY()+30,"Expire","Ok"))

 

[Fluff]

I have absolutely no idea what you mean.

Please post some sample data (not an image) showing expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[MohdTareq007]

Date1 Date2 Date3 Statues
01-Feb-22 06-Jun-22 Expired
04-Apr-22 Ok
07-Jul-22 05-Mar-22 Ok

"=IF(MIN(K73:M73)=0,"""",IF(MIN(K73:M73)<TODAY()+10,""Expired"",""Ok""))"

in Column D should also detect Expiring Soon if Date is close to 1 Month

Statues Dates Should Detect, Expired, Expiring Soon and if date is good more than 1 month then ok

 

[Fluff]

Please use the XL2BB add-in to post your data. What you have provided is pretty meaningless.
Also you want to add another criteria, but what you have posted does not show that.

 

[MohdTareq007]

Sorry I didn't KNOW XL2BB

 

[Fluff]

Follow the link in post#13