If Formula

[eramirez148]

How can I add the following results in the "Status' column. I want it to read today's date and if today's date falls withing the range of "VP start" and VPer.End" then the results should be "Active" if todays date is outside the range then "Not Active"

	Todays Date	10/30/2023​
VP Start	VPer.End	Status
11/1/2021	10/22/2023	Not Active
3/31/2023	11/24/2023	Active
3/31/2023	11/24/2023	Active
3/24/2023	11/24/2023	Active
3/24/2023	11/24/2023	Active
11/1/2023	12/1/2023	Not Active

 

[johnny51981]

I think you might want this:

=LOOKUP(Todays Date Cell,VP Start Column,Status Column)

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	VP Start	VPer.End	Status
2	01/11/2021	22/10/2023	Not active
3	31/03/2023	24/11/2023	Active
4	31/03/2023	24/11/2023	Active
5	24/03/2023	24/11/2023	Active
6	24/03/2023	24/11/2023	Active
7	01/11/2023	01/12/2023	Not active
Data

Cell Formulas
Range	Formula
C2:C7	C2	=IF(MEDIAN(TODAY(),A2,B2)=TODAY(),"Active"," Not active")