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)

 

[Saurabhj]

Hi, Great if you can share the excel sheet having data using XL2BB. It would help us to understand the query better and can provide the solution.

Book1
	A	B	C	D
1	23-Nov-22	12-Jan-22	15-Feb-22
2
3
4	Fresh	Expired	About to Expire
5
6
7
8
9
10
Sheet1

Cell Formulas
Range	Formula
A4:C4	A4	=IF(TODAY()-A1>0,"Expired",IF(A1-TODAY()<=30,"About to Expire",IF(A1-TODAY()>30,"Fresh","Check")))

 

[EFANYoutube]

Hi Mohd
Try this in E1

=IF(OR(A1<NOW()+30,B1<NOW()+30,B1<NOW()+30),"Expire","OK")

 

[Fluff]

Hi & welcome to MrExcel.
Another option

=IF(MIN(A1:C1)<TODAY()+30,"Expire","Ok")

 

[MohdTareq007]

Saurabhj ang Fluff thank you both for your time and consideration. The formulas you provided only works on singula cells although am looking forward to formula calculations or detect expiry date 1, 2 and 3 and provides indication on expire status column
I have attched the above photo

 

[EFANYoutube]

Hi Mohd
Try this in E1

=IF(OR(A1<NOW()+30,B1<NOW()+30,B1<NOW()+30),"Expire","OK")

Just put this in E1 and fill down

 

[Fluff]

The formulas you provided only works on singula cells

No they work on 3 cells, but you never mentioned anything about blank cells. Should blank cells be ignored?

 

[MohdTareq007]

View attachment 57127
Saurabhj ang Fluff thank you both for your time and consideration. The formulas you provided only works on singula cells although am looking forward to formula calculations or detect expiry date 1, 2 and 3 and provides indication on expire status column
I have attched the above photo

Yes blank cells should be ignored

No they work on 3 cells, but you never mentioned anything about blank cells. Should blank cells be ign

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	K	L	M	N
7
8		05/01/2022	06/01/2022	Expire
9	01/04/2022	05/01/2022	09/09/2022	Expire
10	01/04/2022	01/06/2022		Ok
11
12
Entry

Cell Formulas
Range	Formula
N8:N11	N8	=IF(MIN(K8:M8)=0,"",IF(MIN(K8:M8)<TODAY()+30,"Expire","Ok"))

 

[MohdTareq007]

Thank you so much, worked ok